ODBC_SQLGetCursorName

4D v18


ODBC_SQLGetCursorName ( stmtID ; cursorName ) -> 戻り値

引数	型	説明
stmtID	倍長整数	Statement ID
cursorName	文字	Cursor name
戻り値	倍長整数	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.

Function Results

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

参照

ODBC_SQLExecDirect
ODBC_SQLSetCursorName