how to remove processed rows from client .odb file ?
648161Jul 7 2008 — edited Sep 30 2008Hi,
In my app, the user can work on PDA on items that are checked out for him. When he is done with the job, it can mark the processed item as "processed" (just a boolean flag PROCESSED in the table of items) and on next sync, the record should disappear from its list of items on PDA.
The problem is that in order to make this work I set a filter in my data subset ("... WHERE PROCESSED=0").
Everything works as expected, except that items with PROCESSED = 1 do not disappear from my local .odb file on client after sync (I assume that they are simply ignored, since they do no longer match the sync query).
Of course I could make my app remove them after sync, but I wondered if there was not a way to get a 'strict' sync that would also remove items that do not match sync filters (Of course, no "refresh" sync can be done here, since some items may have been updated although not yet marked as "processed")
Guillaume