Writing upload_update scripts

The MobiLink server uses this event during processing of the upload to handle rows updated at the remote database. The following UPDATE statement could be used as an upload_update script for the emp table.

UPDATE emp
SET emp_name = {ml r.emp_name}
WHERE emp_id = {ml o.emp_id};

Notes

When using question marks instead of named parameters as placeholders, the number of parameters can be equal to one of the following (the use of question marks in SQL scripts has been deprecated):
- The number of non-primary key columns + primary key columns.
- 2 * (the number of non-primary key columns + primary key columns).
The column order must consist of non-primary key columns first, followed by one of the following:
- The primary key columns.
- All the columns.

Writing upload_update scripts

Notes

See also