dbsync_app.get_result_status()

Returns the status of the last synchronization operation.

Syntax

FUNCTION get_result_status( )
  RETURNS STRING
Returns:

  1. The sync status string.

    Values can for example be "success", "tabinfo_invalid_table", "apply_changes_failed", "schema_mismatch", ...

Usage

The get_result_status() function provides the status of the last synchronization operation.

This status string helps DB Sync client apps to solve synchronization errors.

Details about the issue can be found with the dbsync_app.get_result_events() function. The event type provides the exact reason for the failure, such as "update_denied", when the current user is not allowed to modify existing rows in and SQL table.