|
DaoRecordset:UpdateOptions Access/Assign |
  
|
|
DaoRecordset:UpdateOptions Access/Assign |
|
Purpose
A long 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).
Remarks
The setting or return value can be any of the following constants:
| Constant | Uses |
| dbCriteriaKey | (Default) Jjust the key column(s) in the where clause. |
| dbCriteriaModValues | Key column(s) and all updated columns in the where clause. |
| dbCriteriaAllCols | Key column(s) and all the columns in the where clause. |
| dbCriteriaTimeStamp | Just the timestamp column if available (will generate a run-time error if no timestamp column is in the result set). |
| dbCriteriaDeleteInsert | Set of DELETE and INSERT statements for each modified row. |
| dbCriteriaUpdate | (Default) UPDATE statement for each modified row. |
Class