TAdoQuery.LoadFromFile with D7-Access97

From: user@xxxxxxxxxxxxxx
Date: Fri, 26 Aug 2005 15:51:45 +0200

I use D7 with a Access97 database. In one application i need to export one entire table to XML, delete the records from the table, and then reimport the XML file. The first part works ok, but i can't find a way to reimport the data in my table there are no records at all.

This is the code:

MainDM is a DataModule
QR is a TAdoQuery

MainDM.QR.SQL.Text := 'DELETE * FROM '+ExpFile;
MainDM.QR.ExecSQL;

MainDM.QR.CursorType := ctKeySet;
MainDM.QR.LockType   := ltBatchOptimistic;
MainDM.QR.SQL.Text   := 'SELECT * FROM TableName';
MainDM.QR.Open;
MainDM.QR.LoadFromFile(FileName);
MainDM.QR.UpdateBatch(arAll);
MainDM.QR.Close;

Someone can help?


Giorgio Forti
.

Follow-Ups:
- Re: TAdoQuery.LoadFromFile with D7-Access97
  - From: Brian Bushay TeamB

Prev by Date: Re: Alter table and update with ADO
Next by Date: ADO Question
Previous by thread: Alter table and update with ADO
Next by thread: Re: TAdoQuery.LoadFromFile with D7-Access97
Index(es):
- Date
- Thread