OdbcCloseQuery

Syntax

OdbcCloseQuery(str_dbidentifier);

str_dbidentifier

The identifier specified in OdbcConnect.

Description

Closes any open queries (statements) in the data source. An open query exists when OdbcGetFirst has been executed and all rows in the result set have not been retrieved with OdbcGetNext. Closing the query means that all resources allocated by the query will be released. OdbcGetNext cannot be called after OdbcCloseQuery has been called. This function should only be called when you are certain that you that you will not want to retrieve any more data from the current query.

If no data is found when OdbcGetFirst or OdbcGetNext tries to retrieve data, these functions will automatically call OdbcCloseQuery to close the query.

Returns

1	All open queries have been closed successfully.
-1	No open query exists.

Example

OdbcCloseQuery("my_identifier");