Contents Index Writing upload_fetch scripts Writing download_cursor scripts

MobiLink Synchronization User's Guide
  Writing Synchronization Scripts

Writing scripts to download rows


There are two scripts that can be used for processing each table during the download transaction. These are the download_cursor script, which carries out inserts and updates, and the download_delete_cursor script, which carries out deletes.

These scripts are either SELECT statements or calls to procedures that return result sets. The MobiLink synchronization server downloads the result set of the script to the remote database. The MobiLink client automatically inserts or updates rows based on the download_cursor script result set, and deletes rows based on the download_delete_cursor event.

For more information about using stored procedures, see Downloading a result set from a stored procedure call.

The MobiLink synchronization server downloads data in a single transaction. For a description of the download process, see Events during download.

Notes 

Writing download_cursor scripts
Writing download_delete_cursor scripts

Contents Index Writing upload_fetch scripts Writing download_cursor scripts