Options Argument

Options arguments can be one or more of the following enumeration members.

CommandTypeEnum Members

Member

Value

Description

adCmdUnspecified

-1

Hidden. No command type is specified.

adCmdText

1

The Source argument is a command or the name of a stored procedure.

adCmdTable

2

The Source argument is the name of a table.

adCmdStoredProc

4

The Source argument is the name of a stored procedure.

adCmdUnknown

8

Default. The type of command in the Source argument is unknown.

adCmdFile

256

The Source argument is the name of a stored Recordset.

adCmdTableDirect

512

The Source argument is the name of a table. This option cannot be combined with adAsyncExecute.

ExecuteOptionEnum Members

Member

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 Source argument is a command or stored procedure that does not return records.

adExecuteStream

1024

Hidden. Specifies the result of the command execution be returned as a stream. Can be used only with the Command.Execute method.

adExecuteRecord

2048

Hidden. The Source argument is a command or stored procedure that returns a single row as a Record object.

0 0

Post a comment