property is used to set the characteristics of a key item. You can:
- Determine if an item is key for an item defined in the data model editor or through programming
- Define a key item (when the item is described through programming).
// Define the characteristics of the Orders.OrdID key
Orders.OrdID.KeyType = hUniqueKey
// Validate the data file description
Determining if an item is key Hide the details
<Characteristic> = <Data file>.<Item>.KeyType
<Characteristic>: Integer constant
The characteristics of an item are:
|hDuplicatesKey||Key with duplicates. This item can have the same value for several data file records.|
|hNotAKey||The item is not a key.|
New in version 28hPrimaryKey |Primary key. The value assigned to this item will not be null and will only be in the data file. |
|hUniqueKey||Unique key. The value assigned to this item will be unique in the data file. No file record will have the same value for this item.|
<Data file>: Character string
Name of the data file used. This name was defined in the data model editor or with the File Description type.
<Item>: Character string
Name of the item used. This name was defined in the data model editor or with the Item Description type.