version 2004
ODBC_SQLGetCursorName (stmtID; cursorName) Longint
Parameter | Type | Description | |
stmtID | Longint | Statement ID | |
cursorName | String | Cursor name | |
Function result | Longint | Returns the result of the MS ODBC API function | |
SQLGetCursorName |
Description
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 at http://msdn.microsoft.com/library/en-us/odbc/htm/odbcsqlgetcursorname.asp.
Function Results
SQL_SUCCESS, SQL_SUCCESS_WITH_INFO, SQL_ERROR, or SQL_INVALID_HANDLE.
Example
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'")
See Also
ODBC_SQLExecDirect, ODBC_SQLSetCursorName.