4D v13
ODBC_SQLGetCursorName
- 4D ODBC Pro
-
- ODBC_Prepare requests
-
- Preparing SQL Requests
- ODBC_SQLBindParameter
- ODBC_SQLGetCursorName
- ODBC_SQLPrepare
- ODBC_SQLSetCursorName
ODBC_SQLGetCursorName
| ODBC_SQLGetCursorName ( stmtID ; cursorName ) -> Function result | ||||||||
| Parameter | Type | Description | ||||||
| stmtID | Longint |
|
Statement ID | |||||
| cursorName | String |
|
Cursor name | |||||
| Function result | Longint |
|
Returns the result of the MS ODBC API function SQLGetCursorName | |||||
The ODBC_SQLGetCursorName command returns the cursor name associated with a statement. Cursor names are used only in positioned update and delete statements.
stmtID is a valid statement ID returned by ODBC_SQLAllocStmt.
cursorName is the name of the cursor that was previously set by ODBC_SQLSetCursorName.
For more information, please see the SQLGetCursorName function in the MS ODBC API Reference at http://msdn.microsoft.com/en-us/library/ms716209(VS.85).aspx.
SQL_SUCCESS, SQL_SUCCESS_WITH_INFO, SQL_ERROR, or SQL_INVALID_HANDLE.
The following method sets a cursor name and then retrieves it. After some processing, the cursor is used to update data in the table:
$result:=ODBC_SQLSetCursorName($statementID;"C1")
$result:=ODBC_SQLExecDirect($statementID;"SELECT ID, Name FROM Employee")
$result:=ODBC_SQLGetCursorName($statementID;vNewCursorName)
.
. `more processing...
.
$result:=ODBC_SQLExecDirect($newStmt1;"UPDATE Employee SET Name='Test' WHERE 'CURRENT OF C1'")
Product: 4D
Theme: ODBC_Prepare requests
Number:
16976
Created: 4D ODBC Pro 2004
ODBC_SQLExecDirect
ODBC_SQLSetCursorName
