ODBC_SQLSetPos

4D v16

ODBC_SQLSetPos


ODBC_SQLSetPos ( stmtID ; rowNb ; operation ; lockType ) -> 戻り値

引数	型	説明
stmtID	倍長整数	Statement ID
rowNb	倍長整数	Position of the row in the rowset on which to perform the operation specified with the operation argument
operation	倍長整数	Operation to perform
lockType	倍長整数	Specifies how to lock the row after performing the operation
戻り値	倍長整数	Returns the result of the MS ODBC API function SQLSetPos

説明

The ODBC_SQLSetPos command sets the cursor position in a rowset and allows an application to refresh data in the rowset or to update or delete data in the result set.

stmtID is a valid statement ID returned by ODBC_SQLAllocStmt.

rowNb is the position of the row in the rowset on which to perform the operation specified with the operation argument. If 0, then the operation applies to every row in the rowset.

operation is the operation to perform and can be one of the following constants:

Constant	Value	Description
SQL_POSITION	0	Driver positions the cursor on the row specified by rowNb
SQL_REFRESH	1	Driver positions the cursor on the row specified by rowNb and refreshes data in the rowset for that row
SQL_UPDATE	2	Driver positions the cursor on the row specified by rowNb and updates the underlying row of data with the values in the row set
SQL_DELETE	3	Driver positions the cursor on the row specified by rowNb and deletes the underlying row of data

lockType specifies how to lock the row after performing the operation:

Constant	Value	Description
SQL_LOCK_NO_CHANGE	0	Driver or data source ensures that the row is in the same locked or unlocked state as it was before ODBC_SQLSetPos was called
SQL_LOCK_EXCLUSIVE	1	Driver or data source locks the row exclusively
SQL_LOCK_UNLOCK	2	Driver or data source unlocks the row

For more information, please see the SQLSetPos function in the MS ODBC API Reference at http://msdn.microsoft.com/en-us/library/ms713507(VS.85).aspx.

Function Results

SQL_SUCCESS, SQL_SUCCESS_WITH_INFO, SQL_NEED_DATA, SQL_STILL_EXECUTING, SQL_ERROR, or SQL_INVALID_HANDLE.

参照

ODBC_SQLFetchScroll