Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Saving DB files..

Posted on 2000-02-16
3
Medium Priority
?
134 Views
Last Modified: 2010-04-04
I want to save some files of a db (pdox) to a diskette. What I do is:
Table.Active := False;
MkDir('Temp123');
Copy-Files-To-Temp-Dir;
Copy-Files-From-Temp-Dir-To-A:\;
Table.Acitve := True;
The problem is that unless I exit my program and re-enter, recent changes aren't saved to the diskette.
I've tried to use Table.Edit, Table.Post but it didn't work.
Any ideas as to how I can solve this problem?

Omri
0
Comment
Question by:GoodTimes
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 12

Accepted Solution

by:
rwilson032697 earned 300 total points
ID: 2530095
Hi Omri,

You should call ApplyUpdates on each of your tables to commit cached changes to the DB files.

Cheers,

Raymond.
0
 
LVL 12

Expert Comment

by:rwilson032697
ID: 2530097
Oh, you should also call the FlushBuffers method, just to be sure :-)

Cheers,

Raymond.
0
 

Author Comment

by:GoodTimes
ID: 2530641
Thanks, what I needed was FlushBuffers. My DB doesn't use Cached Updates..
0

Featured Post

On Demand Webinar: Networking for the Cloud Era

Did you know SD-WANs can improve network connectivity? Check out this webinar to learn how an SD-WAN simplified, one-click tool can help you migrate and manage data in the cloud.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction I have seen many questions in this Delphi topic area where queries in threads are needed or suggested. I know bumped into a similar need. This article will address some of the concepts when dealing with a multithreaded delphi database…
Introduction Raise your hands if you were as upset with FireMonkey as I was when I discovered that there was no TListview.  I use TListView in almost all of my applications I've written, and I was not going to compromise by resorting to TStringGrid…
In this video, Percona Solution Engineer Dimitri Vanoverbeke discusses why you want to use at least three nodes in a database cluster. To discuss how Percona Consulting can help with your design and architecture needs for your database and infras…
In this video, Percona Solutions Engineer Barrett Chambers discusses some of the basic syntax differences between MySQL and MongoDB. To learn more check out our webinar on MongoDB administration for MySQL DBA: https://www.percona.com/resources/we…
Suggested Courses

670 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question