Writing upload_insert scripts

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

The 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