Hello
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:
ADOQuery1.Recordset:=ReturnedRecordset;
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.
Regards
Peter Grahm
ADO RecordSet property.
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.
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.