Name

ExecuteOptionEnum Enumeration — (Versions 2.0, 2.1, 2.5, 2.6)

Synopsis

The ExecuteOptionEnum enumeration indicates how a data provider should execute a command.

Table E-21. The ExecuteOptionEnum Enumeration

Enumeration (ADO/WFC)

Value

Description

adAsyncExecute (ASYNCEXECUTE)
16 (&H10)

Instructs ADO to execute the command asynchronously.

adAsyncFetch (ASYNCFETCH)
32 (&H20)

Instructs ADO to fetch the records returned from this command asynchronously after the initial number of rows (indicated by the CacheSize property) are returned.

adAsyncFetchNonBlocking (ASYNCFETCHNONBLOCKING)
64 (&H40)

Instructs ADO to never block the main thread while executing. If the row that is requested has not been read, it is automatically moved to the end of the file.

adExecuteNoRecords (NORECORDS)
128 (&H80)

Instructs ADO that the CommandText property does not return rows and, if it does, to discard them. This value is always combined with adCmdText or adCmdStoredProc of the CommandTypeEnum enumeration.

adExecuteStream (no ADO/WFC equivalent)

1024 (&H400)

Indicates that the returned object of the Command object’s Execute method will be a Stream object. This value is invalid for all other uses.

ADO/WFC

The ExecuteOptionEnum enumeration is part of the com.ms.wfc.data package, and the constant values are preceded with AdoEnums.ExecuteOption.

See Also

Command.Execute Method, Connection.Execute Method, Recordset.Open Method, Recordset.Requery Method

Get ADO: ActiveX Data Objects now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.