FireDAC.Comp.DataSet.TFDDataSet.SaveToFile
Delphi
procedure SaveToFile(const AFileName: String = ''; AFormat: TFDStorageFormat = sfAuto);
C++
void __fastcall SaveToFile(const System::UnicodeString AFileName = System::UnicodeString(), Firedac::Stan::Intf::TFDStorageFormat AFormat = (Firedac::Stan::Intf::TFDStorageFormat)(0x0));
Contents
Properties
| Type | Visibility | Source | Unit | Parent |
|---|---|---|---|---|
procedure function |
public | FireDAC.Comp.DataSet.pas FireDAC.Comp.DataSet.hpp |
FireDAC.Comp.DataSet | TFDDataSet |
Description
Saves a dataset's data to a file.
Use SaveToFile to write a dataset's data to an external file for later use by this or other datasets.
AFileName is the name of the external file to save the data.
AFormat is the file format:
sfXML--well formed stand-alone XML file.sfBinary--binary file with custom FireDAC format.sfAuto--the format is determined by theAFileNameextension: ".XML" - XML file, ".ADB" / ".BIN" / ".DAT" - binary file. IfAFileNamedoes not have an extension, then the format is determined by the ResourceOptions.DefaultStoreExt if it is specified, otherwise by ResourceOptions.DefaultStoreFormat.
Optional, you can specify ResourceOptions.PersistentFileName before calling Open. In this case data is saved to file at Close, if data was modified or the file does not exist.
If the file exists and ResourceOptions.Backup is set to True, then the original file extension is changed to ResourceOptions.BackupExt, it is saved to ResourceOptions.BackupFolder, and then a new file is written.
SaveToFile stores into the file the items specified by ResourceOptions.StoreItems.
Example
FDQuery1.Open('select * from customers');
FDQuery1.FetchAll;
FDQuery1.SaveToFile('c:\customers.xml', sfAuto);
....
FDMemTable1.LoadFromFile('c:\customers.xml', sfAuto);
FDMemTable1.Locate('CUSTOMER_ID', [100], []);