Fallback on mobile devices.

[classic12]

IOS & Android.

I am using SQLITE to store data locally (e.g. customer table).

The client can make changes or add a new customer while online / offline.

On an update button I need to update the MYSQL table on the server.

What is the best strategy to do this?.

1. Do I need a timedate field to see which is the latest record ?
2. How to had version conflicts ?
3. How do I handle a drop in connection whilst updating. Can I get a callback to say 'customerID 7 updated then I can update in the local SQLITE table. Or a callback saying lost connection then I can try again.


Any ideas / tutorial appreciated.

Mr Warby.

[ViktorV]

These questions are not related to functionality of our products.
This is the scope of main principals of work with databases and of MySQL and SQLite functionality.
Therefore you should refer to the documentation of these database servers.

[classic12]

Ok I have posted on the delphi forums.


So to be more specific how does MyDac handle lost connections over 3G.

Any examples would be great.

Mr Warby.

[ViktorV]

The same question has already been discussed on our forum. Follow the link http://forums.devart.com/viewtopic.php? ... %3B#p82546 for details.