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.
Discuss this page in DocCommentXchange.
|Copyright © 2010, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.0|