Customizing the Data Model

The Data Model Editor enables you to edit the selection options displayed in the Field Selection menus of the SQLWizard. Use it to update the wizard when you have customized the Site database with your own fields and tables.

To edit the query options available in SQLWizard:

1    In the SQLWizard, click Edit Structure. The Data Model Editor is displayed.

2    Select the Fields tab. The editor lists the groups in SQLWizard's Field Selector menu.

To add a new group to the Field Selection menu, right-click an entry in the menus list, choose Add Group and enter a Group Name.

To add a new field to a group:

a    Right-click the group and choose Add Field. The Fields list dialog is displayed.

b    In the Tables list, select the database table that contains the field you want to add to the wizard, then select the field and click OK. The details of the field are displayed in the Field Properties area.

c    Select the Operators tab for the field and edit the list to specify the valid Comparison Operators for the field.

d    Select the Value Editor tab and select a Value type for the field.

3    When you have finished editing the wizard's data model, click OK to close the window and save your changes.

Your changes are available when you create a new condition in your query.

Notes

    Changes made using the Data Model Editor affect only the Console from which it was opened. To make the changes available to other Consoles in your installation, copy LANUTIL32.DBS from the Console's installation directory to the corresponding directory of all the other Console PCs.

    Upgrading the Site database can lose changes made to the Data Model. To preserve any changes, copy LANUTIL32.DBS from the installation directory before starting the upgrade, and copy the file back when the upgrade is complete.