Full text search
function	SQLSetPos

Library: ODBC Include: omodbc.xin

Returns: Numeric An SQL return code. The following values may be returned: SQL_SUCCESS (the row was successfully refreshed). SQL_SUCCESS_WITH_INFO (the row was successfully refreshed, but a message was issued). SQL_ERROR (an error occurred). SQL_INVALID_HANDLE (the handle is invalid). SQL_STILL_EXECUTING (the program is still executing). SQL_NEED_DATA (data is required to refresh the row).

Declaration

  define external counter function SQLSetPos
     (  read-only SQL_handle_type StatementHandle,
        value counter RowNumber,
        value counter Operation,
        value counter LockType )

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.