Generate_Record_ID_Method

The Generate_Record_ID_Method setting indicates how the record identity column is filled.

Supported By

The Generate_Record_ID_Method setting indicates how the record identity column is filled. There are four possible values:

Value	Meaning
None	Record identifiers are not generated by the back-end. Record identity values must be filled by giving the columns an explicit value in the application. When a new record is created, the value in the record identifier column is passed to the back-end.
Identity_Column	The record identifier is filled by the back-end using the features the server provides for this (identity columns). When a new record is created, the value in the record identifier column is not passed to the back-end. This value is only applicable to the SQL Server and DataFlex DB2 Drivers.
External	The record identifier is generated by the back-end but in some other way than using identity columns. For example, one could use triggers. When a new record is created, the value in the record identifier column is not passed to the back-end.
Dispenser_Table	The record identifier value is dispensed from a table that keeps track of the next available record identity value. The dispenser logic is enforced using triggers when records are inserted. When a new record is created, the value in the record identifier column is not passed to the back-end. When a table is opened, a check will be done to see if the triggers, the dispenser table, and the record in the dispenser table for the table being opened exist. If one (or more) of these is missing, it will automatically be created. This value is only applicable to the DataFlex DB2 Driver.