4D v13

ODBC_SQLGetCursorName

Home

 
4D v13
ODBC_SQLGetCursorName

ODBC_SQLGetCursorName 


 

ODBC_SQLGetCursorName ( stmtID ; cursorName ) -> Function result 
Parameter Type   Description
stmtID  Longint in Statement ID
cursorName  String in Cursor name
Function result  Longint in 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.

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

 
PROPERTIES 

Product: 4D
Theme: ODBC_Prepare requests
Number: 16976

 
INDEX

Alphabetical list of commands

 
HISTORY 

Created: 4D ODBC Pro 2004

 
SEE ALSO 

ODBC_SQLExecDirect
ODBC_SQLSetCursorName