Setting advanced IDO attributes

The advanced attributes of an IDO include its primary key properties, and other options.

Primary keys reflect the primary key properties of the IDO's base table in the application or external database. The system automatically detects primary key properties, except for IDOs that are based on SQL views. The order of the IDO's primary key properties should match the order used in the application's underlying database table. This order determines the default sort order for the IDO, which might be overridden in the application or elsewhere.

On the IDOs form, select the IDO to edit.
If necessary, check out the IDO.
Click Advanced Attributes.
In the Advanced IDO Attributes form, the IDO Properties list shows the properties of the IDO that can be designated as primary keys. The Primary Keys list indicates the designated primary keys detected by the system and their sort order.
Optionally, perform any of these actions:
- Add primary keys: Select a property and click Add.
- Set the sort order for the primary keys: Use the Up and Down buttons.
- Remove primary keys: Select a primary key and click Remove.
Optionally, select (or clear) the Quote Table Aliases option.
This option controls whether appropriate quoting is applied to table aliases during SQL generation for the tables in this IDO.
To protect table aliases that represent SQL keywords or reserved words in the query language of the server hosting the table’s database, select this option.
If you selected all table aliases to avoid duplicating SQL keywords, you can clear this option.
To save your changes and close the Advanced IDO Attributes dialog box, click OK.
In the IDOs form, save the IDO record.

Remember to check the IDO back in. Your changes do not become operative until you check them in.