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. |