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.
|options||Optional. Specifies how to execute this command. Can be an ExecuteOptionEnum value|
|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|
Your message has been sent to W3Schools.