CODEWITHSUNDEEP
delphidelphi-xe
mano
mano

Reputation: 308

How to implement Auto Save functionality in Delphi?

I am having a task to Auto Save data after every 5 minutes which is filled in more than one forms however I dont want to save the data in the actual dataset. The main aim of auto save is as there are many fields on the form and the user has typed in details spending his valuable time and during this time if the server goes down then the application would crash thereby loosing the data typed in.

If the application has crashed then next time when the connection takes place then a message should pop up saying "Do you want to recover the lost changes?" once clicked yes then the auto saved form should be shown.

Just a side note my application is working on datasnap model.

Any suggetions how to go about this really appreciated.

Upvotes: 0

Views: 666

Answers (1)

Rohit
Rohit

Reputation: 939

Not sure if this is an option, but perhaps you could deploy the application with a lightweight database (such as SQLite or NexusDB)? If you have a lot of forms with a lot of fields/data, this would make a drafts based solution quite easy to implement.

The idea would be to have a "drafts" table in your local database which is a flat table that will contain and hold all of the data that you want to persist until the transactions are committed to the server database.

Save the data in the forms to this local drafts table (as the user enters them in or on a periodic basis). Once the transactions in the forms are committed to the server database, you can delete the draft record from the local drafts table.

If the app crashes and the user signs back on, you will be able to check the local drafts table and pull the data that you need back into the screen fairly quickly and easily.

Hope this helps.

Upvotes: 0

Related Questions