Execute Method

Microsoft Office Web Components Object Model

Show All

Execute Method

       

Execute method as it applies to the DataSourceControl object.

Returns a Recordset object that represents the recordset resulting from a recordset definition or grouping definition. If the recordset is part of a hierarchy of chaptered recordsets, the data source control creates the entire hierarchy and returns the requested recordset from the hierarchy.

expression.Execute(RecordsetName, ExecuteOption, FetchType)

expression   An expression that returns a DataSourceControl object.

RecordsetName   Required String. The name of the recordset definition or grouping definition.

ExecuteOption   Optional ADO ExecuteOptionEnum. Specifies how the query is performed. The default value is adOptionUnspecified.

FetchType   Optional dscFetchTypeEnum. If the specified recordset definition contains sublist child recordset definitions, setting this argument to dscFull causes all records to be fetched whenever the Execute method is called. If you do not specify this argument or you set it to dscParameterized, records in child recordsets are fetched only when the child recordset is opened for a given parent. For example, if you have a Customers parent with an Orders child and this argument is set to dscFull, all records for all customers are fetched at run time. If this argument is set to dscParameterized, recordsets for customers with Customer ID 'ANTAR' are fetched only when the Customers recordset is positioned on this Customer ID and the child Orders recordset is opened.

 

Execute method as it applies to the OCCommand object.

Executes the specified command.

expression.Execute( )

expression   An expression that returns an OCCommand object.