Connecting to Multiple OLE DB Data Providers or Databases

To connect multiple OLE DB data providers or databases:

  1. Open the VisiconX Data Control OLE Properties dialog box. For information on how to do this in your product, refer to the Accessing VisiconX OLE Control Properties section.
  2. For simplicity, configure the first VisiconX Data Control to access the database and table whose data you want displayed; configure the second Data Control to access the database that supplies the value for the row filter.
  3. Create a query in the first VisiconX Data Control that equates a query property to a column common to both database tables.
  4. Animate the query property, using the data supplied by the second data control as its data source.

NOTE: CIMPLICITY users need to use CimEdit Basic script to use query properties.  For more information, see Using Query Properties in CIMPLICITY.

See Also