ODBC_SQLFreeStmt

4D v17

ODBC_SQLFreeStmt


ODBC_SQLFreeStmt ( stmtID ; option ) -> 戻り値

引数	型	説明
stmtID	倍長整数	Statement ID
option	倍長整数	Option to execute
戻り値	倍長整数	Returns the result of the MS ODBC API function SQLFreeStmt

説明

The ODBC_SQLFreeStmt command stops the processing associated with a specific statement, closes any open cursors associated with the statement, discards pending results, or, optionally, frees all resources associated with the statement handle.

stmtID is a valid statement ID returned by ODBC_SQLAllocStmt.

The option parameter can take one of the following values:

Constants	Description
SQL_CLOSE	Closes the cursor associated with StatementHandle (if one was defined) and discards all pending results
SQL_UNBIND	Sets the SQL_DESC_COUNT field of the ARD to 0, releasing all column buffers bound by SQLBindCol for the given stmtID
SQL_RESET_PARAMS	Sets the SQL_DESC_COUNT field of the APD to 0, releasing all parameter buffers set by SQLBindParameter for the given stmtID
SQL_DROP	Frees the statement handle

For more information, please see the SQLFreeStmt function in the MS ODBC API Reference at http://msdn.microsoft.com/en-us/library/ms709284(VS.85).aspx.

Function Results

SQL_SUCCESS, SQL_SUCCESS_WITH_INFO, SQL_ERROR, or SQL_INVALID_HANDLE.

例題

See the example for the ODBC_SQLFetch command.

参照

ODBC_SQLAllocStmt
ODBC_SQLFetch