Capturing script results

Regardless of whether a script is executed manually or automatically, the results of the script execution are stored on the MobiLink client.

On SQL Anywhere clients, the results are stored in the dbo.sync_passthrough_status table. The results consist of the time at the remote database when the script was executed and an indication of whether the script succeeded or reported an error. In addition, if an error was reported the SQL code and the text of the error message is stored.

On UltraLite clients the results are stored in the syssql table. The results consist of the time at the remote database when the script was executed and an indication of whether the script succeeded or reported an error. In addition, if an error was reported the SQL code, the line number in the script of the statement that failed, and a list of error parameters is stored.