rvadodataprovider TRVReportADODataProvider


<< Click to display table of contents >>

rvadodataprovider TRVReportADODataProvider


A data provider receiving data from ADO (ActiveX Data Objects) data stores.

Unit RVReportAdoDataProvider;


TRVReportADODataProvider = class (TRVReportCustomDBDataProvider)



This component provides data for a report generator component from ADO data stores.

This data provider handles the following data queries:

SQL select statement

table name

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

TRVReportADODataProvider introduces properties:

property Connection: TADOConnection;
property ConnectionString: WideString;

Also: CacheSize, CursorLocation, CursorType, LockType, MaxRecords properties.

Internally, the component uses temporal dbGo (TADOQuery and TADOTable) 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 TADOQuery or TADOTable.

See also

Definitions of Report Workshop terms

Data queries