FDquery LoadfromFile

[McPain 0]

Hi all,

 

I am using Dbgrid with FDquery and have a connection to an MDB database. I can access and save data, all good.

Now I am trying to export the data via fdquery.SaveToFile('Filename.xml', sfAuto ). The procedure is creating an XML file. Also fine.

 

How can I read in (import) this data again?

 

When I try this:

fdquery.LoadFromFile('Filename.xml', sfAuto );

fdquery.Edit;

fdquery.Append;

fdquery.UpdateRecord;

 

I get all data into the DBgrid, but the data is not getting saved into the MDB.

What do I miss?

 

Thx!

Alexander

[Stano 143]

For example, a separate query of type "INSERT INTO"

[Dmitry Arefiev 101]

https://docwiki.embarcadero.com/Libraries/Alexandria/en/FireDAC.Stan.Option.TFDBottomResourceOptions.PersistentFileName

[McPain 0]

why a "insert into" when the DBgrid is permanently connected to the database?

 

The link I got but do not really understand how to add this to my code or processes.

[Stano 143]

DBGrid nepoužívam. Neverím, že ak pustíte DataSet do DBGrid, automaticky to uloží do DB. To by bola obrovská chyba.
Môj pohľad na problém:

• Načítavate údaje zo súboru
• Vložíte ich do DBGrid
• Pracujete s DBGrid
• Ukončili ste DBGrid
• Nikde som si nevšimol: Načítavam dáta zo súboru - načítané dáta uložím do DB!
• Musíte to urobiť sami
• DBGrid to sám od seba neurobí

I looked at the link. I understand that it only works with the file. Not with DB. But I don't know English and my knowledge is poor.

Edited June 29, 2022 by Stano

[Lajos Juhász 293]

1 hour ago, McPain said:

why a "insert into" when the DBgrid is permanently connected to the database?

After you save the data to the file. Someone can edit the file or the original data in the database, thus the program should figure out how to merge back the data.

[McPain 0]

yes the data is inside the file up2date, but when I refresh the old data from the DB come in.

 

My goal:

- enter data into Dbgrid

- save into XML

 

- load data from XML to present data inside DBgrid

[weirdo12 19]

On 7/18/2022 at 6:47 AM, McPain said:

yes the data is inside the file up2date, but when I refresh the old data from the DB come in.

 

Refresh meaning you call TFDQuery.Refresh?

[McPain 0]

yes I tried this as well. After refresh the DGbrid show the old data, so no update is happening to the database.