Databases Reference
In-Depth Information
adCmdUnknown
The
Source
argument type is unknown.
These values can be combined with values that relate to asynchronous fetching of
records:
adAsyncExecute
The
Source
should be executed asynchronously. A FetchComplete event will fire
when the operation is complete.
adAsyncFetch
After the initial quantity specified in the Initial Fetch Size property is fetched, any
remaining rows are fetched asynchronously. If a required row has not yet been
fetched, further code execution is blocked (halted) until the requested row
becomes available.
adAsyncFetchNonBlocking
This is similar to
adAsynchFetch
, except that further code execution is never
blocked. If the requested row has not been fetched, the current row automatically
moves to the end of the file.
It is important to close a recordset using the
Close
method when the recordset is
no longer required. However, closing the recordset does not remove the
Recordset
object from memory, so its properties may still be accessed or altered. In order to
remove the
Recordset
object from memory, we must set the recordset variable
that references the object to
Nothing
.
Requery
Updates the recordset by requerying the data source.
Resync
Resynchronizes the recordset with the underlying data. It differs from the
Requery
method in that it does not re-execute the original query that produced the
recordset. Hence, it will cause any changes to existing records to be visible, but it
will not show any new records.
Supports
Gets information on what features are supported for recordsets of the specified
type by the data provider. The syntax is:
