Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 11.0.0 » MobiLink - Server Administration » Using MobiLink Technology » Synchronization techniques » Timestamp-based downloads


Using last download times in scripts

The last download timestamp is provided as a parameter to many MobiLink events. The last download timestamp is the value obtained from the consolidated database during the last successful synchronization immediately prior to the download phase. If the current MobiLink user has never synchronized, or has never synchronized successfully, this value is set to 1900-01-01.

See How download timestamps are generated and used.

If you have multiple publications and have synchronized them at different times, then you can have two different last download timestamps. For this reason, there are two script parameter names for last download timestamps:

  • last_table_download   is the last download timestamp for a table.

  • last_download   is the last time all tables were synchronized. It is the earliest last_table_download value for any table.

When you use question marks instead of named parameters in MobiLink scripts, the correct value is always used.


If you are using a SQL Anywhere consolidated database and the column holding last modified information is of type DEFAULT TIMESTAMP, then the column should not be synchronized. If your remote databases require such a column, a different column name should be used. Otherwise, the default timestamp value may be overridden by the uploaded value, and does not contain the time that the row was last modified on the consolidated database.

See also
SELECT cust_id,, Customer.rep_id
FROM Customer KEY JOIN SalesRep
WHERE Customer.last_modified >= {ml s.last_table_download}
    AND SalesRep.ml_username = {ml s.username}
    AND = 1

How download timestamps are generated and used