Save and Load dataset to file

Discussion of open issues, suggestions and bugs regarding SDAC (SQL Server Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
gpnunes
Posts: 7
Joined: Fri 17 Aug 2007 14:08

Save and Load dataset to file

Post by gpnunes » Fri 17 Aug 2007 14:51

Hi, I'm looking for a dataset where I can save a dataset to file and after can load this file to another dataset.

I tested the trial version and I could export dataset to XML file, but I can't load this file again I couldn't a "loadfromfile" method or similar.

Can I do that with SDAC?

Regards
Gustavo

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

Post by Antaeus » Mon 20 Aug 2007 06:56

You should use the VirtualTable component to load data from xml files.

gpnunes
Posts: 7
Joined: Fri 17 Aug 2007 14:08

Save and Load dataset to file

Post by gpnunes » Mon 20 Aug 2007 15:03

Hi Antaeus,

Thank you I use the virtual table, and it works very well, Now i have another question.

Can I order the result set in Virtual table?
Thanks
Gustavo

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

Post by Antaeus » Tue 21 Aug 2007 06:51

You should use the IndexFieldNames property of TVirtualTable to perform sorting.

Post Reply