procedure ConfigCDSFromAdoQuery(p_ADOQ: TADOQuery; p_CDS: TClientDataset; p_Prov: TDatasetProvider);
If p_ADOQ.Active then p_ADOQ.Close;
p_ADOQ.CursorLocation := clServer;
p_ADOQ.CursorType := ctOpenForwardOnly;
p_Prov.Dataset := p_ADOQ;
p_CDS.PacketRecords := 100;
@Vlad: The process is always the same: connect TClientDataset(CDS) with a TDatasetProvider(DSP), after that point the property DSP.DataSet property to the ADOQuery you're bringing the data. In Delphi section on About.com you can find thousands of examples and in the embarcadero docwiki too.
EDIT -> It would be something on the lines of this:
I've done this all by code, but most of that you can do in design-time.
Thanks, I will try to make a sample project, but still a demo with "Server (cursor location?) OpenForwardOnly cursor and an TCLientDataset with PacketRecords set to nonzero value" would be great! ;)
You could use that adoTable with an Server OpenForwardOnly cursor and
an TCLientDataset with PacketRecords set to nonzero value. Worked
wonderfully when I had to write an app to pump data from MSSQL to
Oracle on a customized way with tables with millions of records.
how do I connect the TCLientDataset with my MSACCESS? Do you have some sample code you can share?