Close a result set.

Defined in

ODBCResultSet

Syntax

status = odbcResultSet.Close [ (option ) ]

Parameters

option

Constant. DB_CLOSE to close the entire result set (this is the default) or DB_CANCELADDROW to close only the AddRow workspace.

status

Boolean.

The ODBCResultSet object still exists, but the data is purged. Most methods raise the DBstsNOEX (no Execute) error on a closed result set because the data is gone. You can use the object properties, including Query, so you can "reopen" the data with Execute.

A result set can be used after disconnecting from the data source, but no additional data can be fetched and no updates can be posted. To fetch all data in one pass, set the CacheLimit property to DB_ALL, execute the query, and call the LastRow method (to force fetching and traversal of all data satisfying the query). Now you can disconnect and use the data in the result set.

Events

BeforeClose

AfterClose

Example
See Also

AddRow method
Disconnect method (in ODBCConnection)

Glossary