Record Modification Modes

Constant

Modification mode

Autoselection

gdbExtDBModAutoAll

Autoselection of all modes. This constant is not permitted to use with other constants.

Adding records

gdbExtDBModAutoAdd

Autoselection of add mode.

gdbExtDBModAPIAdd

Adding records by API functions of ODBC driver.

gdbExtDBModSQLAdd

Adding records by an SQL statement INSERT.

Updating records

gdbExtDBModAutoUpdate

Autoselection of update mode.

gdbExtDBModAPIUpdate

Updating records by API functions of ODBC driver.

gdbExtDBModSQLUpdate

Updating records by a positioned statement UPDATE.

gdbExtDBModKeySQLUpdate

Updating records by the statement UPDATE. The record being updated is identified by values of fields that belong to the primary key of a table or by values of fields that belong to the unique index of a table. To use this mode, the Recordset::KeyFields collection must contain fields which values uniquely identify records in the recordset.

Deleting records

gdbExtDBModAutoDel

Autoselection of delete mode.

gdbExtDBModAPIDel

Deleting records by API functions of ODBC driver.

gdbExtDBModSQLDel

Deleting records by a positioned statement DELETE.

gdbExtDBModKeySQLDel

Deleting records by the statement DELETE. The record being deleted is identified by values of fields that belong to the primary key of a table or by values of fields that belong to the unique index of a table. To use this mode, the Recordset::KeyFields collection must contain fields which values uniquely identify records in the recordset.

Recordset

gdbExtDBModAutoForUpdate

To use a statement SELECT ... FOR UPDATE for generating a recordset if necessary.

gdbExtDBModForUpdate

To use a statement SELECT ... FOR UPDATE for generating a recordset.

gdbExtDBModNoForUpdate

Do not use a statement SELECT ... FOR UPDATE for generating a recordset.