Managing database types

A relational list is defined by an SQL query. You might need different versions of the same query to account for differences in the way in which different database providers implement SQL. You can write multiple list SQL queries and store them as a single list. On the Advanced tab of a relational database alias, you can specify which version of the queries will be used.

See Advanced.

Queries written for the Default database type are used if Type Indifferent is selected on the Advanced tab of the database alias.

To create multiple relational list definitions:

  1. Create or edit a relational list.
    The Relational List Designerdialog box is displayed. <Default> is selected in the Database type list.

    See relational list.

  2. Click Manage Database Types from the Database type list.
    The Database Types dialog box is displayed.
  3. Click New and specify a unique name, caption and description.
    For example, specify 'For MS SQL Server databases only' as a description.
  4. Add further database types as required.
  5. Click OK.
    The Relational List Designer is displayed and the database types which you create become available on the Advanced tab of the relational database alias.
  6. Select a database type from the Database type list.
  7. Specify a SQL statement appropriate to the selected type.
  8. Select different database types and specify different SQL statements as required.
  9. Click OK.
Parent topic: Relational lists