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 illustrates the use of the upload_update statement.

UPDATE emp
SET emp_name = {ml r.emp_name}
WHERE emp_id = {ml o.emp_id};
Notes
  • When synchronizing a remote database using MobiLink client version 9.0 or earlier, or when using question marks instead of named parameters as placeholders, the number of parameters can be equal to one of the following:
    • 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.
See also