cancel
Showing results for 
Search instead for 
Did you mean: 

UltraLite - get time of last sync

1,567

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

Accepted Solutions (1)

Accepted Solutions (1)

VolkerBarth
Contributor

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

Breck_Carter
Participant

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

VolkerBarth
Contributor
0 Kudos

So you're saying that's a way lesser WAG? 🙂

Answers (1)

Answers (1)

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.