Execute Method

Executes the constructed SQL statement on the Data Source and returns a System.Data.DataSet object with the data returned from the Data Source.

Syntax

public override System.Data.DataSet Execute( 
   ActiveLocalExecution execution,
   System.bool sortAndFilter,
   System.bool hasCartesianData
)

execution: Defaults to null
sortAndFilter: Set to true if the returned data set should be sorted and filtered by any in-memory sorts. Defaults to false.
hasCartesianData: Typically used when a report is requesting the execution of SQL, and the report contains a Cartesian product. Defaults to false

A data set with the results of the query from the Data Source

Exceptions

Exception	Description
WrAllSqlStatementsGeneratedException	WrAllSqlStatementsGeneratedException is thrown if this SqlObject object is not to be executed, but ec=xists only for the generation of a constructed statement. If the IsSqlGenerationOnly property is true, this exception is thrown.