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
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...
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