rvpgdataprovider TRVReportUniDataProvider

Events

<< Click to display table of contents >>

rvpgdataprovider TRVReportUniDataProvider

Events

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)

hmtoggle_arrow1Hierarchy

Description

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.

See also

Definitions of Report Workshop terms

Data queries