Hello everybody, we are using UltraLite 16 on a Windows platform. What we want to display on the UI is the time of the last synchronization. I wonder if there is a API (or even better a SQL statement) that can give me that. If not, we can note down the timestamp ourself, but it would be slick if we could get it from the db itself. Thanks and best regards, Alex asked 10 Mar '15, 06:38 Alexander Ilg |
A wild guess based on the docs:
should give the according time. For SQL Anywhere ML clients, the according value would be contained in column "last_download_time" in SYSSYNC2 (or SYSSYNC). Here also the "last_upload_time" is documented. I can't tell whether the timestamp values are based on server or client time... answered 10 Mar '15, 07:00 Volker Barth 1
Hmmm... what would Watcom do? Server time, or total chaos? :) Seriously... "After an upload is committed and immediately before invoking the prepare_for_download event, the MobiLink server fetches the current time from the consolidated database and saves the value."
(10 Mar '15, 07:30)
Breck Carter
Replies hidden
So you're saying that's a way lesser WAG? :)
(10 Mar '15, 07:33)
Volker Barth
|
The typical way to query information about the last synchronization is the GetSyncResult API. It populates a ul_sync_result structure containing the local time of the last synchronization, along with upload status, error status, and data transfer statistics. There is also the SYSSYNCRESULT system table which provides the same information. answered 10 Mar '15, 15:52 Tim McClements |