Tom1s Member Licensed User Longtime User Mar 16, 2015 #1 Hi I got the RDC server running and now I try to figure out the right path/modules... I would need offline table/rows in mobile end so that it could work even if connection to RDC in not available. Should I use SQL or Keyvaluestore to store the rows? When connection is established the data/table could be tranferred. In mobile app I need 2 tables and when clicking the row it goes to the another table. Think it is better to use flexible table than customlistview? Thanks for pointing the direction..
Hi I got the RDC server running and now I try to figure out the right path/modules... I would need offline table/rows in mobile end so that it could work even if connection to RDC in not available. Should I use SQL or Keyvaluestore to store the rows? When connection is established the data/table could be tranferred. In mobile app I need 2 tables and when clicking the row it goes to the another table. Think it is better to use flexible table than customlistview? Thanks for pointing the direction..
Tom1s Member Licensed User Longtime User Mar 16, 2015 #2 What if I make offline changes and then go online.... If I use SQL is there a sync script(command) to sync tables and look for changes? Or should I write the commands in a file and execute those after connection is on again? If I understand correctly all RDC tutorials assumes that connection is on all the time. I try to look the best solution but perhaps cant ask the right questions... Last edited: Mar 16, 2015 Upvote 0
What if I make offline changes and then go online.... If I use SQL is there a sync script(command) to sync tables and look for changes? Or should I write the commands in a file and execute those after connection is on again? If I understand correctly all RDC tutorials assumes that connection is on all the time. I try to look the best solution but perhaps cant ask the right questions...
Erel B4X founder Staff member Licensed User Longtime User Mar 16, 2015 #3 Tom1s said: If I understand correctly all RDC tutorials assumes that connection is on all the time. Click to expand... RDC does one thing only. It allows your app to communicate with a remote database. If there is no connection then the request will fail. You can create a local database and update it from time to time with RDC. You will need to implement the synchronization yourself. You can for example add a last modified time for each record and then sync the new records between the local and the remote databases. Upvote 0
Tom1s said: If I understand correctly all RDC tutorials assumes that connection is on all the time. Click to expand... RDC does one thing only. It allows your app to communicate with a remote database. If there is no connection then the request will fail. You can create a local database and update it from time to time with RDC. You will need to implement the synchronization yourself. You can for example add a last modified time for each record and then sync the new records between the local and the remote databases.