MobiLink Synchronization Reference
Synchronization Events
An example event for the upload stream to handle rows updated at the remote database. The example script is not called by MobiLink but is identical in form to the upload_update event.
Clause | Parameters |
---|---|
SET |
column 1
column 2 ... |
WHERE |
primary key 1
primary key 2 ... |
You create an example_upload_update event script by using the option -za in the dbmlsync command line.
This example handles updates made to the Customer table in the remote database. The script updates the values in a table named Customer in the consolidated database. Note: The script is never called and is only an example script.
UPDATE Customer SET name=?, rep_id=? WHERE cust_id=?