on 2015 Mar 10 6:38 AM
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
Request clarification before answering.
A wild guess based on the docs:
SELECT download_timestamp from SYSPUBLICATION WHERE publication_name = 'YourChoice';
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...
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
server or client time
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."
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
52 | |
8 | |
5 | |
5 | |
5 | |
5 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.