4D v14.1
ODBC_SQLSetPos
- 4D ODBC Pro
-
- ODBC_Results
-
- Retrieving Results and Information, Introduction
- ODBC_SQLBindCol
- ODBC_SQLBulkOperations
- ODBC_SQLColAttribute
- ODBC_SQLDescribeCol
- ODBC_SQLFetch
- ODBC_SQLFetchScroll
- ODBC_SQLGetData
- ODBC_SQLGetDescField
- ODBC_SQLGetDescRec
- ODBC_SQLGetDiagField
- ODBC_SQLGetDiagRec
- ODBC_SQLMoreResults
- ODBC_SQLNumResultCols
- ODBC_SQLRowCount
- ODBC_SQLSetDescField
- ODBC_SQLSetDescRec
- ODBC_SQLSetPos
ODBC_SQLSetPos
| ODBC_SQLSetPos ( stmtID ; rowNb ; operation ; lockType ) -> Function result | ||||||||
| Parameter | Type | Description | ||||||
| stmtID | Longint |
|
Statement ID | |||||
| rowNb | Longint |
|
Position of the row in the rowset on which to perform the operation specified with the operation argument | |||||
| operation | Longint |
|
Operation to perform | |||||
| lockType | Longint |
|
Specifies how to lock the row after performing the operation | |||||
| Function result | Longint |
|
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.
SQL_SUCCESS, SQL_SUCCESS_WITH_INFO, SQL_NEED_DATA, SQL_STILL_EXECUTING, SQL_ERROR, or SQL_INVALID_HANDLE.
Product: 4D
Theme: ODBC_Results
Number:
16948
Created: 4D ODBC Pro 2004
4D ODBC Pro ( 4D ODBC Pro v11.4)
4D ODBC Pro ( 4D ODBC Pro v12)
4D ODBC Pro ( 4D v13)
4D ODBC Pro ( 4D v14 R3)
4D ODBC Pro ( 4D v14.1)
4D ODBC Pro ( 4D v14 R2)
4D ODBC Pro ( 4D v14 R4)
