Overview Checklist

The following steps outline the procedural checklist you should follow to retrieve data from an OLE DB data provider and display it in either iFIX or CIMPLICITY:

To retrieve data from an OLE DB data provider and display it in iFIX:

  1. Insert a Data Control into your iFIX WorkSpace picture.
  2. In the Data Control OLE Properties dialog box, configure the Data Control to connect to an OLE DB data provider and database; test the connection.
  3. In the same dialog box, select the database table or tables to query and create your query using any of the methods provided by VisiconX.
  4. In your WorkSpace picture, insert a Grid, ListBox, and/or ComboBox Control in which to display the retrieved data.
  5. On the Behavior tab of the Animations dialog box, animate the Grid, ListBox, and ComboBox Controls. For the animation data source, select the Data Control and choose Object in the Data Conversion drop-down list box.
  6. To view your picture in Run mode:

In Ribbon view, on the Home tab, in the Workspace group, click Switch to Run.

- Or -

In Classic view, on the Standard toolbar, click Switch to Run.

To retrieve data from an OLE DB data provider and display it in CIMPLICITY:

  1. Insert a Data Control into your CIMPLICITY CimEdit screen.
  2. In the Data Control OLE Properties dialog box, configure the Data Control to connect to an OLE DB data provider and database; test the connection.
  3. In the same dialog box, select the database table or tables to query and create your query using any of the methods provided by VisiconX.
  4. In your CimEdit screen, insert a Grid, ListBox, and/or ComboBox Control in which to display the retrieved data. Select a Data Control source for the control(s) you insert.
  5. Save your CimEdit screen and open it in CimView's run-time environment.

See Also