TRVReportDBXDataProvider [VCL; FMX]|
<< Click to display table of contents >>
|
A data provider receiving data from databases via dbExpress drivers, including Oracle, Firebird, InterBase, DB2, Informix, SQL Server, MySQL and ODBC.
Unit RVReportDBXDataProvider;
Syntax
TRVReportDBXDataProvider = class (TRVReportCustomDBDataProvider)
TObject TPersistent TComponent |
This component provides data for a report generator component from databases via dbExpress drivers, including Oracle, Firebird, InterBase, DB2, Informix, SQL Server, MySQL and ODBC.
This data provider handles the following data queries:
•SQL select statement
•table name
To use this component, assign it to DataProvider property of TRVReportGenerator.
TRVReportDBXDataProvider introduces properties:
property SQLConnection: TSQLConnection;
Also: SchemaName, ObjectView.
Internally, the component uses temporal TSQLQuery components to handle data queries. The data provider properties and events are assigned to these components. If you want to assign additional properties to them, use OnDataSetCreated event.
In addition to the default query processing, you can provide another DataSet component in OnCreateDataSet event. This DataSet is not necessary needed to be TSQLQuery.
