CommandText Property

  • Article

Returns or sets the command string for the specified object. Read-only String for the RecordsetDef and SchemaRowsource objects; read/write String for all other objects in the AppliesTo list.

expression.CommandText

*expression   * Required. An expression that returns one of the objects in the Applies To list.

Remarks

For type dscCommandText, this property returns or sets a text string (usually SQL) that returns a single result set from the provider.

For type dscCommandFile, this property returns or sets the URL of an XML file containing data for the specified SchemaRowsource object.

Applies to | ChartSpace Object | PivotTable Object | RecordsetDef Object | SchemaRowsource Object | Worksheet Object

See Also | Connection Property | ConnectionString Property