ADO RecordSet property.

Discussion of open issues, suggestions and bugs regarding SDAC (SQL Server Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
Posts: 5
Joined: Tue 22 Jul 2008 10:36

ADO RecordSet property.

Post by SpeedyC » Tue 22 Jul 2008 11:18


Trying to convert an application that currently using ADO components to SDAC, I encounter problems on that we have a third party component that returns an ADO recordset and I directly load it into a TADOQuery like:


My idea was that you could use the TVirtualTable instead but the help is a bit vague to me at least.

TVirtualTable.LoadFromFile states that it can load a XML document in ADO compatible format. Is there any example on doing this?

There will also be an upcoming task for me to transfer data returned from a Query to a ADO recordset in the third party component stated previously.

I would greatly appreciate any information on converting ADO recordsets SDAC.

Peter Grahm

Posts: 2098
Joined: Tue 14 Feb 2006 10:14

Post by Antaeus » Wed 23 Jul 2008 06:54

You can find an example that demonstrates working with TVirtualTable within SDAC demo projects (SDAC_Inst_Dir\Demos\Win32\SdacDemo\). Open the SdacDemo.dpr, build it and select the VirtualTable item in the tree.
Data from SDAC datasets can be saved to ADO-compatible XML file, and then loaded with ADO components.
There is no way to transfer data directly between recordsets of ADO and SDAC datasets.

Post Reply