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?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

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
ste5anSenior DeveloperCommented:
Sorry, I don't speak French..
0
HTML5 and CSS3 Fundamentals

Build a website from the ground up by first learning the fundamentals of HTML5 and CSS3, the two popular programming languages used to present content online. HTML deals with fonts, colors, graphics, and hyperlinks, while CSS describes how HTML elements are to be displayed.

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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
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
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Delphi

From novice to tech pro — start learning today.