4D Doc Center : ODBC_SQLGetCursorName

Home

4D v14.1

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

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 Reference at http://msdn.microsoft.com/en-us/library/ms716209(VS.85).aspx.

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'")