rvsqldataprovider TRVReportSQLDataProvider [LCL]


<< Click to display table of contents >>

rvsqldataprovider TRVReportSQLDataProvider [LCL]


A data provider receiving data from various SQL databases, for Lazarus.

Unit RVReportSQLDataProviderLaz;


TRVReportSQLDataProvider = class (TRVReportCustomDBDataProvider)



This component provides data for a report generator component from various SQL databases, including Firebird,Microsoft SQL Server, Sybase ASE, MySQL.

This data provider handles the following data queries:

SQL select statement

table name (without space characters)

To use this component, assign it to DataProvider property of TRVReportGenerator.

TRVReportSQLDataProvider introduces the properties:

property Database: TDatabase;
property Transaction: TSQLTransaction;

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.

See also

Definitions of Report Workshop terms

Data queries