ODBC_SQLFreeStmt

4D v17

ODBC_SQLFreeStmt


ODBC_SQLFreeStmt ( stmtID ; opcion ) -> Resultado

Parámetro	Tipo	Descripción
stmtID	Entero largo	Statement ID
opcion	Entero largo	Option to execute
Resultado	Entero largo	Returns the result of the MS ODBC API function SQLFreeStmt

Descripción

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.

Ejemplo

See the example for the ODBC_SQLFetch command.

Ver también

ODBC_SQLAllocStmt
ODBC_SQLFetch