SQL Anywhere database - Last Modified Timestamp

Author

Last Modified Timestamp

Robert

2005-07-19, 7:23 am

Have Proc which begins
ALTER PROCEDURE "DBA"." mlsp_pictures_downlo
ad_cursor"(IN @last_modified
TIMESTAMP,IN @ml_user VARCHAR(255))

the @last_modified variable. Where does this come from? Is it linked to the
ml_user table?
I update my ASA record from 2 possible places. One from a device and the
second from an off line program.
The datetime stamp updates correctly but the newly modified record does not
download to the device.
I actually want all records updated since the last download to be sent.
ASA version 9.0.2.3044
Mobilink Version 9.0.2.3044

Greg Fenton

2005-07-19, 9:23 am

Robert wrote:
> Have Proc which begins
> ALTER PROCEDURE "DBA"." mlsp_pictures_downlo
ad_cursor"(IN @last_modified
> TIMESTAMP,IN @ml_user VARCHAR(255))
>
> the @last_modified variable. Where does this come from? Is it linked to the
> ml_user table?

I assume that you have this stored procedure being called by a MobiLink
event (based on its name and its parameter names).

Different events in ML are passed different parameters. For
download_cursor events, they are passed two parameters:

last_download and ml_username

The last_download value is the timestamp of the last time this
particular remote synchronized. Since you are using ML 9.x, this value
is set by ML at the start of each download phase, downloaded to the
remote, and the value that your script receives is the value that was
downloaded from the previous synchronization session (thus "last"_download).

This timestamp is in "consolidated" time since it is generated by ML at
the consolidated. So you don't need to worry about timezone offsets or
skewed clocks at the remotes.

The ml_username is the id of the user currently synchronizing. It is
the "SYNCHRONIZATION USER" value set in an ASA remote or the value
passed to dbmlsync with the "-u" parameter.

BTW: for follow-up questions relating the MobiLink, try the newsgroup:

sybase.public.sqlanywhere.mobilink

greg.fenton
--
Greg Fenton
Consultant, Solution Services, iAnywhere Solutions
--------
Visit the iAnywhere Solutions Developer Community
Whitepapers, TechDocs, Downloads
http://www.ianywhere.com/developer/

Robert

2005-07-19, 9:23 am

Thanks Greg
last_download - Is this store somewhere on the database in ASA or only on
ML.

Greg Fenton

2005-07-19, 11:23 am

Robert wrote:
> Thanks Greg
> last_download - Is this store somewhere on the database in ASA or only on
> ML.

It is stored in the SYS.SYSSYNC table, in the "last_download_time" column.

greg.fenton
--
Greg Fenton
Consultant, Solution Services, iAnywhere Solutions
--------
Visit the iAnywhere Solutions Developer Community
Whitepapers, TechDocs, Downloads
http://www.ianywhere.com/developer/

Sponsored Links