Close (ODBCResultSet - LotusScript)
Close a result set.
Defined in
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.
Return value
status
Boolean.
Usage
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