SQLSelect.ScrollUpdateType Property |  |
A constant, which describes the type of SQL statement to use during append, update or delete operations.
Namespace: VO
Assembly: VOSQLClasses (in VOSQLClasses.dll) Version: 2.21
SyntaxRequest Example
View Source
A constant, which describes the type of SQL statement to use during append, update or delete operations.
Property Value
Type: UsualA constant, which describes the type of SQL statement to use during append, update or delete operations.
Remarks
One of the following constants, which describes the type of SQL statement; searched (by key or value) or positioned (by cursor) to use during append, delete, or update operations:
| Constant | Description |
|---|---|
| SQL_SC_UPD_AUTO | The system determines which type of SQL statement to use: attempting to use cursor, key, and value, respectively. The type that applies first is used. This is the default. |
| SQL_SC_UPD_CURSOR | The cursor position is used. |
| SQL_SC_UPD_KEY | The key(s) specified in the primary key are used. |
| SQL_SC_UPD_VALUE | The value(s) of all the columns in the row are used. |
See Also