The following tables list the values you can specify for the Command.Execute method's options argument.
J.1.1. CommandTypeEnum Values
The CommandTypeEnum values specify how the Connection.CommandText argument is to be interpreted.
Constant
Value
Description
AdCmdUnspecified
−1
Hidden. No command type is specified.
AdCmdText
1
The CommandText argument is a command or the name of a stored procedure.
AdCmdTable
2
The CommandText argument is the name of a table.
AdCmdStoredProc
4
The CommandText argument is the name of a stored procedure.
AdCmdUnknown
8
Default. The type of command in the CommandType argument is unknown.
AdCmdFile
256
The CommandText argument is the name of a stored Recordset (Recordset.Open or Requery methods only).
AdCmdTableDirect
512
The CommandText argument is the name of a table (Recordset.Open or Requery methods only). This option cannot be combined with adAsyncExecute.
J.1.2. ExecuteOptionEnum Values
The ExecuteOptionEnum values specify how the provider is to execute the Connection.CommandText argument.
Constant
Value
Description
AdOptionUnspecified
−1
Hidden. The command is not specified.
AdAsyncExecute
16
The command executes asynchronously. This option cannot be combined with adCmdTableDirect.
AdAsyncFetch
32
The rows that remain to be retrieved after those specified by the CacheSize property are to be retrieved asynchronously.
AdAsyncFetchNonBlocking
64
The main thread never blocks while retrieving data, so if the requested row has not been retrieved, the current row automatically moves to the end of the file.
This setting is ignored if the adCmdTableDirect option is used, or if you open a recordset from a stream that contains a persistently stored recordset.
AdExecuteNoRecords
128
The CommandText argument is a command or stored procedure that does not return records.
AdExecuteStream
1024
Return the results of a command operation as a Stream (Command.Execute only).
AdExecuteRecord
2048
Hidden. The CommandText argument is a command or stored procedure that returns a single row as a Record object.
Note: For information about how to view hidden objects in the Object Browser, refer to Chapter 2.
