We manage our company tasks via a simple client application (...Yet
Another ToDoList): two Clientdatasets in a Master/Detail relationship
(cdsProjects + cdsTasks) linked to a central network database.
Associated to every task we can also have N Attachments, saved as BLOB
field in another table of the database. So we use a parametrical
dataset (SELECT * FROM DOCS WHERE idTask = :idTask), represented by
cdsDocs ad configured as detail for cdsTasks.
Now, I would like to implement an "offline mode" for this application,
so that I could edit my tasks and view the documents even when
disconnected from the network, and eventually sync the edited content
once reconnected.
I'd like the same "user transparency" level of Microsoft Outlook
cached mode.
I was wondering which could be the best solution for implementing this
feature:
- Manually cache all the database content into an access database?
Manually sync the updates once "Online"?
- Use the cds.SaveToFile/LoadFromFile method? If yes, how can i manage
the Master/Detail relationships?
- Other suggestions?
Thanks,
Oliver