ADO Requery Method

## ADO Tutorial

ADO HOME ADO Intro ADO Connect ADO Recordset ADO Display ADO Query ADO Sort ADO Add ADO Update ADO Delete ADO Demo ADO Speed Up

## ADO Objects

ADO Command ADO Connection ADO Error ADO Field ADO Parameter ADO Property ADO Record ADO Recordset ADO Stream ADO DataTypes
ADO Summary

## ADO Examples

ADO Examples

# 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

## Your suggestion:

Your E-mail (optional):

Page address:

Description:

Close [X]

## Thank You For Helping Us!

Your message has been sent to W3Schools.

Close [X]
Search w3schools.com:

## WEB HOSTING

Best Web Hosting UK Reseller Hosting Wow! $5 SSD Hosting

## WEB BUILDING

Download XML Editor
FREE Website BUILDER FREE Website Creator

## WEB RESOURCES

Web Statistics Web Validation

## SHARE THIS PAGE