McPain

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

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

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.

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