CdbRecordset::SetUpdateOptions, GetUpdateOptions Property

Sets or returns a value that indicates how the WHERE clause is constructed for each record during a batch update, and whether the batch update should use an UPDATE statement or a DELETE followed by an INSERT (ODBCDirect workspaces only).

Syntax

VOIDSetUpdateOptions(LONG l);

LONGGetUpdateOptions(VOID);

Set Parameters

Type Example Description
LONG l A Long with one or more of the values specified in Settings.

Settings

Constant Description
dbCriteriaKey (Default) Uses just the key column(s) in the WHERE clause.
dbCriteriaModValues Uses the key column(s) and all updated columns in the WHERE clause.
dbCriteriaAllCols Uses the key column(s) and all the columns in the WHERE clause.
dbCriteriaTimeStamp Uses just the timestamp column if available (will generate a run-time error if no timestamp column is in the result set).
dbCriteriaDeleteInsert Uses a set of DELETE and INSERT statements for each modified row.
dbCriteriaUpdate (Default) Uses an UPDATE statement for each modified row.