How to keep my table full where using timer(Delphi 7 , Paradox 9)

Hello everyone,
I'm using Timer to upload data to my table paradox every day but when i close the application the table become empty(it can be closed because of the shutdown of the computer all of a sudden) , i want to keep my table full  , any solutions please.
I'm using Delphi 7 and paradox 9 thanks.
Toutou la bellaAsked:
Who is Participating?
 
Ferruccio AccalaiSenior developer, analyst and customer assistance Commented:
In paradox if a table never closed could loose all data if an accidental application close occurs (maybe called be a system shutdown or application error or an electrical fault)
You could just close the table (and maybe post if in edit/insert mode) in the form onclosequery event
Anyway It's better to use a query with a insert into statement instead of having live open table. Less memory usage and better performances, in addition to saving yourself from such a situation
0
 
ste5anSenior DeveloperCommented:
Is it cached? Then you need to call .ApplyUpdates to persist the data.
1
 
Toutou la bellaAuthor Commented:
I called .ApplyUpdates and i got this message Capture.PNG
0
Cloud Class® Course: Certified Penetration Testing

This CPTE Certified Penetration Testing Engineer course covers everything you need to know about becoming a Certified Penetration Testing Engineer. Career Path: Professional roles include Ethical Hackers, Security Consultants, System Administrators, and Chief Security Officers.

 
ste5anSenior DeveloperCommented:
Sorry, I don't speak French..
0
 
Toutou la bellaAuthor Commented:
@Ste5an the message is : the table is not in cache edit mode
0
 
Toutou la bellaAuthor Commented:
Thanks Ferruccio Accalai it works .
0
 
Toutou la bellaAuthor Commented:
Thanks Ferruccio Accalai it works.
0
 
Ferruccio AccalaiSenior developer, analyst and customer assistance Commented:
Well glad for that, but take care that if the application shuts down due to an AV error or the PC it's turned off unfriendly  (electric lack or forced turn off), then you could have the same issue. Maybe a query update in every ontimer event is better.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.