Key options

The database type specified for a table determines which sets of key options are available for each key. The following key options are important to understand in the Report Writer:

Duplicates   Specifies whether multiple records in the table can have the same key value. If this option is marked, new records that have the same key values as records already in the table can be saved. If the option isn’t marked, new records with the same key values as existing records won’t be saved.

Create Index   If this option for SQL tables is marked, an index in the SQL database will be created for the table based upon this key definition. The index contains a copy of the data in the key’s key segments and pointers to the associated records in the table. An index allows data to be retrieved from the table more quickly.

If Create Index is marked, the following options are available:

• Unique   Marking this option ensures that the records in this table will have unique values for this key.
• Clustered   Marking this option sorts and physically stores the data in the table according to the order defined by this key. For example, the Customer table has a key based upon the Customer Name field. If this key was based on the Customer Name field, and the Clustered option were marked for the key, the data in the Customer table would be physically stored in the order indicated by the key. Only one key per table can have the Clustered option marked.

Documentation Feedback

---