Execute OptionEnum Members

The ExecuteOption enumeration specifies how the provider is to execute the Connection.CommandText argument.

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 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.

For information about how to view hidden objects in the Object Browser, refer to Chapter 2.

0 0

Post a comment