TRVReportUniDataProvider [VCL]|
<< Click to display table of contents >>
|
A data provider receiving data from multiple databases via UniDAC, including Oracle, Microsoft SQL Server, MySQL, InterBase, Firebird, PostgreSQL, SQLite, DB2, Microsoft Access, Sybase Advantage Database Server, Sybase Adaptive Server Enterprise, and other databases (using ODBC provider).
Unit RVReportUniDataProvider;
Syntax
TRVReportUniDataProvider = class (TRVReportCustomDBDataProvider)
TObject TPersistent TComponent |
This component provides data for a report generator component from multiple databases, including Oracle, Microsoft SQL Server, MySQL, InterBase, Firebird, PostgreSQL, SQLite, DB2, Microsoft Access, Sybase Advantage Database Server, Sybase Adaptive Server Enterprise, and other databases (using ODBC provider). It uses UniDAC components by Devart.
This data provider handles the following data queries:
•SQL select statement
•table name
To use this component, assign it to DataProvider property of TRVReportGenerator.
TRVReportUniDataProvider introduces properties:
property Connection: TUniConnection;
Also: Options, FetchRows, FetchAll, DataTypeMap, Encryption, SmartFetch properties, AfterQueryExecute, AfterQueryFetch events.
Internally, the component uses temporal TUniQuery and TUniTable 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 TUniQuery or TUniTable.
