we are using SQL Anywhere 16 on Windows in combination with MobiLink and a UltraLite db on iOS, Android and Win 8.
On the client we create a shopping basket, the entries of this basket are stored in a UltraLite database table. The challenge we have now is to only send specific rows of this table to the server.
Is it possible in MobiLink to only upload specific rows of a table to the central SQL Anywhere database?
Thanks for your help, Alex
asked 29 Oct '14, 08:30
Absolutely. You'll need someway to determine which rows you want to send. In the simple sample below, when sync_row = 1, the row is uploaded.
CREATE TABLE t1 ( pk integer primary key default global autoincrement, data varchar(128), sync_row tinyint default 0 ); CREATE PUBLICATION p1 ( TABLE t1 WHERE sync_row = 1 )
answered 29 Oct '14, 09:14
To cite from the topic UltraLite client synchronization design from the v16 docs:
So in your case a WHERE filter might do the trick (besídes the usual filtering that rows that have not been modified since the last upload will be excluded from the upload by default).
answered 29 Oct '14, 09:16