MobiLink Synchronization User's Guide
Writing Synchronization Scripts
Introduction to synchronization scripts
Generating scripts automatically
When you build an UltraLite application, the UltraLite generator automatically inserts an example_upload_cursor script and an example_download_cursor script into the UltraLite reference database. The action of the example download script is to download all rows of a corresponding table that exists in the remote database. These scripts specify the select list in the correct order, and the example_upload_cursor script also includes the correct WHERE clause.
The example scripts are inserted into the ml_scripts table, but they are not used unless you insert an entry in the ml_table_script table that associates them with the upload_cursor or download_cursor event, respectively.
Minimally, the example scripts for download cursors provide the order of columns expected by the remote database.