Friday, 15 May 2015

Zumero sync: knowing what tables are changed -



Zumero sync: knowing what tables are changed -

i have kind of situation. mobile app designed technicians has background task perform info syncinc (it's planned each 10 minutes), , of info in db there's no problems of doing often, doesn't alter often. have parameters table need know when changes, because involves time-consuming operations on mobile device, , i'd when changes, or postpone them. possible accomplish zumero ? thanks. rodolfo.

it's undocumented (so, not guaranteed future proof), can check next before , after sync:

select max(z_rv) parameters; select count(*) parameters;

if updates or inserts have occurred, z_rv increase. alter in count() grab deletes.

zumero

No comments:

Post a Comment