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 - Getting Started » MobiLink Tutorials » Exploring the CustDB sample for MobiLink » Synchronizing CustDB

 

Synchronizing products in the CustDB sample

Business rules

All rows are downloaded for ULProduct—this is called snapshot synchronization.

See Snapshot synchronization.

The business rules for the ULProduct table are as follows:

  • Products can only be modified at the consolidated database.
  • Each remote database contains all of the products.
Downloads

Product information can be inserted, deleted, or updated at the consolidated database. The script corresponding to these operations is as follows:

  • download_cursor¬†¬† The following download_cursor script downloads all of the rows and columns of the ULProduct table at each synchronization:
    SELECT prod_id, price, prod_name FROM ULProduct