Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 12.0.0 » MobiLink - Client Administration » SQL Anywhere clients for MobiLink » Scripted upload » Defining stored procedures for scripted upload

 

Defining stored procedures for updates

The stored procedure for updates must return a result set that includes two sets of values:

  • The first set of values specifies the pre-image for the update (the values in the row the last time it was received from, or successfully uploaded to, the MobiLink server).

  • The second set of values specifies the post-image of the update (the values the row should be updated to in the consolidated database).

This means that the stored procedure for updates must return a result set with twice as many columns as the insert or delete stored procedure.

 Example