Watch, Follow, &
Connect with Us

For forums, blogs and more please visit our
Developer Tools Community.


Welcome, Guest
Guest Settings
Help

Thread: Clearing the cache to release file locks


This question is not answered. Helpful answers available: 2. Correct answers available: 1.


Permlink Replies: 1 - Last Post: Jun 5, 2014 8:49 PM Last Post By: Dmitry Arefiev
keith crusius

Posts: 1
Registered: 5/19/03
Clearing the cache to release file locks  
Click to report abuse...   Click to reply to this thread Reply
  Posted: Jun 5, 2014 8:34 AM
I'm using FireDac with ADS 11.1 with XE5. If I open a TFDTable and then close it and try to do a reindex via SQL (which requires exclusive access) I get a 7008 error. I'm feeling that FireDac is probably caching the table or something that causes the error. If I don't open and close the table first then the reindexing works just fine. If I set the TFDConnection.connected = FALSE then back to TRUE it releases the locks and I can reindex, but that seems a bit drastic - there must be a function to release whatever is locking the table but I can't find it.
Dmitry Arefiev

Posts: 1,406
Registered: 12/7/03
Re: Clearing the cache to release file locks  
Click to report abuse...   Click to reply to this thread Reply
  Posted: Jun 5, 2014 8:49 PM   in response to: keith crusius in response to: keith crusius
Try to call TFDTable.Disconnect instead of Close.

--
With best regards,
Dmitry Arefiev / FireDAC Architect
Legend
Helpful Answer (5 pts)
Correct Answer (10 pts)

Server Response from: ETNAJIVE02