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