The ExecuteOption class contains the fields shown in the following table.
Constant | Value | Description |
UNSPECIFIED | -1 | Indicates that the command is unspecified. |
ASYNCEXECUTE | 0x10 | Indicates that the command should execute asynchronously. |
ASYNCFETCH | 0x20 | Indicates that the remaining rows after the initial quantity specified in getCacheSize should be fetched asynchronously. |
ASYNCFETCHNONBLOCKING | 0x40 | Indicates that the main thread never blocks while fetching. If the requested row has not been fetched, the current row automatically moves to the end of the file.
If you open a Recordset from a Stream containing a persisted Recordset, ASYNCFETCHNONBLOCKING will not have an effect; the fetch will be synchronous and blocking. |
NORECORDS | 0x80 | Indicates that the command text is a command or stored procedure that does not return rows (for example, a command that only inserts data). If any rows are retrieved, they are discarded and not returned. Always combined with CommandType values TEXT or STOREDPROC. |