Android Question RDC+SQL+[Class] Flexible Table?

Tom1s

Member
Licensed User
Longtime User
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..
 
Sort by date Sort by votes

Tom1s

Member
Licensed User
Longtime User
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:
Upvote 0

Erel

B4X founder
Staff member
Licensed User
Longtime User
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
You must log in or register to reply here.

Similar Threads

  • Solved
Android Question [Class] Flexible Table
Replies
8
Views
716
Sergey_New
  • Locked
  • Question
Android Question Variable table name through jRDC
2
Replies
22
Views
8K
Erel
  • Locked
  • Article
B4J Library [B4X] jRDC2 - B4J implementation of RDC (Remote Database Connector)
5 6 7
Replies
138
Views
171K
Erel
  • Locked
  • Article
Android Tutorial Remote Database Connector (RDC) - Connect to any remote DB
20 21 22
Replies
423
Views
358K
Erel
M
  • Article
B4A Library [Class] Flexible Table
64 65 66
Replies
1K
Views
410K
klaus
Menu
Log in
Register
Cookies are required to use this site. You must accept them to continue using the site. Learn more…