Search found 2 matches

by faulknernolan
Wed 20 Jul 2022 08:44
Forum: MySQL Data Access Components
Topic: Savetofile for TMyQuery
Replies: 6
Views: 11520

Re: Savetofile for TMyQuery

pavelpd wrote: Fri 18 Feb 2022 11:52 Hi there!

MyDAC supports data export to XML format using the TMyQuery.SaveToXML method. You can find more details about this method in our documentation (please note that you can implement data export to other formats from your side):
http://www.devart.com/mydac/docs/index. ... toxml.htm fall guys

Kindly note that if you want to save a query execution result, and then open it - you can do it using the VirtualTable component. You can use methods SaveToFile and LoadFromFile for data loading and saving in VirtualTable on all the supported platforms (please note that data will be saved as binarie).

You can assign a TMyQuery to a TVirtualTable. You can read about to fill TVirtualTable with data from another TDataSet component in the VirtualTable help: https://www.devart.com/virtualdac/docs/ ... ject).htm

For example:

Code: Select all

VirtualTable.Assign(MyQuery); 
Should you have any questions, do not hesitate to ask!
Thanks for your reply