Associating data with a graph

When using a graph in a DataWindow object, you associate axes of the graph with columns in the DataWindow object.

The only way to get data into a graph in a DataWindow object is through columns in the DataWindow object. You cannot add, modify, or delete data in the graph except by adding, modifying, or deleting data in the DataWindow object.

You can graph data from any columns retrieved into the DataWindow object. The columns do not have to be displayed.

NoteAbout the examples The process of specifying data for a graph is illustrated below using the Printer table in the EAS Demo DB. The EAS Demo DB is installed with PowerBuilder. The demo database that ships with SQL Anywhere contains many of the same tables as EAS Demo DB, but it does not have the Printer table.

You can add the Printer table to a SQL Anywhere database from the ISQL Session view of the PocketBuilder Database painter by:

  1. Pasting the contents of the Printer.SQL file that the PocketBuilder setup program installs in the Code Examples\SQL directory in the PocketBuilder path.

  2. Selecting the Execute icon in the Database painter toolbar (or selecting Design>Execute ISQL from the main menu) while connected to a SQL Anywhere database on the desktop.

  3. Synchronizing the desktop database with a remote database on the device or emulator (for runtime display on a Windows CE platform).

StepsTo specify data for a graph:

  1. If you are creating a new graph, the Graph Data dialog box displays. Otherwise, select Properties from the graph's pop-up menu and select the Data tab in the Properties view.

  2. Fill in the boxes as described in the sections that follow, and click OK.