A data provider receiving data from various SQL databases, for Lazarus.
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)
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.