ADO Requery Method
Complete Recordset Object Reference
The Requery method updates the data in a Recordset by re-executing the query
that made the original Recordset.
Tip: Use this method to refresh the entire contents of a Recordset.
Note: With this method you call the Close and Open methods in one.
Syntax
objRecordset.Requery options
|
Parameter |
Description |
options |
Optional. Specifies how to execute this command. Can be an
ExecuteOptionEnum
value |
ExecuteOptionEnum Values
Constant |
Value |
Description |
adOptionUnspecified |
-1 |
Unspecified command |
adAsyncExecute |
16 |
The command should execute asynchronously. Cannot be combined with the CommandTypeEnum
value adCmdTableDirect
|
adAsyncFetch |
32 |
The remaining rows after the initial
quantity specified in the CacheSize property should be retrieved asynchronously |
adAsyncFetchNonBlocking |
64 |
The main thread never blocks while
retrieving. If the requested row has not been retrieved, the current
row automatically moves to the end of the file.
If you open a Recordset from a Stream containing a persistently stored Recordset,
adAsyncFetchNonBlocking will not have an effect; the operation will be synchronous and
blocking. adAsynchFetchNonBlocking has no effect
when the adCmdTableDirect option is used to open the Recordset |
adExecuteRecord |
512 |
The CommandText is a command or
stored procedure that returns a single row which should be returned as
a Record object |
Complete Recordset Object Reference
|
|
|