Insert Database Exchange on a graphics page using the
Citect Graphics Builder.
Double-click the Database Exchange object to display the
Properties dialog box.
Click the Connection tab and then click
On the Data Link Properties dialog box, select
Microsoft OLE DB Provider for ODBC Drivers and then click
Select Demo on the DSN list.
Optionally, select the data directory from the list as
Initial Catalog to use. (This setting is included in the DSN
Test the connection and then click OK.
If the schema is retrieved successfully, you should be
able to see all the DBF files located in your Example project
directory on the list on the Database Exchange properties form.
Select a DBF file you want to display from the list and then click
Sometimes MDAC might not be configured correctly
for ODBC drivers, so multiple-step OLE DB operation would generate
errors during open schema process. It means that no DBF files are
listed on the dropdown list. In this case, you should use either
Unknown or SQL Statement as the record source type. For example, if
you want to display data from Recipes.dbf file, you could use the following
Using type Unknown – type Recipes in the Unknown Command
Using type SQL Statement – type
Select * From Recipes in the SQL Statement field.
Note: If SQL Statement is used, you can use
aWhere clause to filter the displayed data. For instance, you could
enter Select * From Recipes Where
As a result, there would be a record displayed on
the control. You can use any DBF file in the configured folder as a