A data provider receiving data from various databases using Zeos Lib.
TRVReportZEOSDSDataProvider = class (TRVReportCustomDBDataProvider)
This data provider handles the following data queries:
•SQL select statement (must start from "select")
•table name (without space characters)
•table or view name with space characters (will be automatically transformed to select * from "table name" query)
TRVReportZEOSDSDataProvider introduces the property:
property Connection: TZConnection;
Internally, the component uses temporal TZQuery and TZTable 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 TZQuery or TZTable.