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. |
|
|
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
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access