Visual Basic Reference

  • Article

Advanced Tab (Command Properties Dialog Box)

See Also

The Command Properties dialog box is divided into six tabs. The General, Parameters, and Advanced tabs are used for setting properties of the Command and Parameter objects, while the Relation, Grouping, and Aggregates tabs are used for setting properties that are specific to Command hierarchies.

On the Advanced tab, specify Recordset management and other information relating to the current Command object.

RecordSet Management

This frame contains the control group pertaining to the management of the Recordset objects.

Cursor Type

Specifies the type of cursor to use for the Command object: Forward Only, Keyset, Dynamic, or Static. The default is Forward Only.

Cursor Location

Specifies the location of the cursor library for the Command object.

Lock Type

Specifies the type of lock that the provider uses to open a Command object: Read Only, Pessimistic, Optimistic, or Batch Optimistic. The default is Read Only.

Cache Size

Specifies the cache size to use for the Command object. The default is 10 records.

Recordset Returning

Specifies whether the Recordset object returns information.

Note   If you want to return both a Recordset and an output parameter, you must create two Command objects, one with Recordset returning selected, and the other with it not selected.

Command Configuration

This frame contains the control group that specifies timeout and record configuration information.

Command Timeout

The number of seconds to timeout when the Command cannot be executed. The default is 30 seconds.

Max Records

The maximum number of records that can return from a data source. The default is 0, which means infinite.

Prepare Before Execution

Specifies whether the command is prepared on the first invocation. Valid values are True or False. The default is False.

All Records

Specifies whether all records are returned upon execution of the Command object. If selected, Max Records is set to 0 and the edit control is disabled.

Call Syntax

The call syntax that ADO uses to call the stored procedure. This can be edited to adjust the number of parameters and presence of the return value.