Writing upload_insert scripts

The MobiLink server uses this event during processing of the upload to handle rows inserted into the remote database.

Following is an INSERT statement used in an upload_insert script.

INSERT INTO emp ( emp_id, emp_name )
VALUES ( { ml r.emp_id }, { ml r.emp_name } );
Notes
  • The upload_new_row_insert and upload_old_row_insert events accept remote_id and user_name as extra parameters. These parameters must appear prior to the full column list of the table.
See also