Syntax
define external counter function SQLSetPos
( read-only SQL_handle_type StatementHandle,
value counter RowNumber,
value counter Operation,
value counter LockType )
Purpose
Sets the cursor position in a row set and allows an application to refresh data in the row set, or to update or delete data in the result set.
Input arguments:
- StatementHandle.
- RowNumber. The position of the row in the row set on which to perform the operation specified with the Operation argument. If RowNumber is zero (0), the operation will apply to every row in the row set.
- Operation. The operation to perform. The following values are allowed: SQL_POSITION, SQL_REFRESH, SQL_UPDATE, and SQL_DELETE.
- LockType. Specifies how to lock the row after performing the operation specified in the Operation argument. The following values are allowed: SQL_LOCK_NO_CHANGE, SQL_LOCK_EXCLUSIVE, and SQL_LOCK_UNLOCK.
|