iX V6.5 (30391-90011)

104 Chapter4

Using the Database

Entering Data in the Database

be used to establish a lock covering the entry to be inserted. For detail data sets, this can

be a data entry, data set, or database lock. For master data sets, this can be a data set or a

database lock. Note that the locking mechanism accepts a request to lock a data entry that

does not yet exist; therefore, you can lock a data entry before you add it.

Key and Search Items

TurboIMAGE/XL performs checks on the values of detail data set search items before

adding an entry to a data set. When adding records to a manual master, TurboIMAGE/XL

veriﬁes that the master data set key item value is unique for the set (that is, no entry

currently contains a key item with the same value). If the data set is a detail,

TurboIMAGE/XL veriﬁes that the value of each search item forming a path with a manual

master has a matching key value in that master. It also checks to be sure that room is

available to add an entry to any automatic master data sets linked to the detail if a

matching search item value does not exist.