UltraLite Embedded SQL User's Guide
Embedded SQL Library Functions
ul_bool ULGetSynchResult( ul_synch_result * synch-result );
Stores the results of the most recent synchronization, so that appropriate action can be taken in the application:
The application must allocate a ul_synch_result object before passing it to ULGetSynchResult. The function fills the ul_synch_result with the result of the last synchronization. These results are stored persistently in the database.
The function is of particular use when synchronizing applications on the Palm Computing Platform using HotSync, as the synchronization takes place outside the application itself. The SQLCODE value set in the call to ULPalmLaunch reflects the ULPalmLaunch operation itself. The synchronization status and results are written to the HotSync log only. To obtain extended synchronization result information, call ULGetSynchResult after a successful ULPalmLaunch.
synch-result A structure to hold the synchronization result. It is defined in ulglobal.h as follows:.
typedef struct {
an_sql_code sql_code;
ul_stream_error stream_error;
ul_bool upload_ok;
ul_bool ignored_rows;
ul_auth_status auth_status;
ul_s_long auth_value;
SQLDATETIME timestamp;
ul_synch_status status;
} ul_synch_result, * p_ul_synch_result;
where the individual members have the following meanings:
sql_code The SQL code from the last synchronization. For a list of SQL codes, see Error messages indexed by Adaptive Server Anywhere SQLCODE.
stream_error The communication stream error code from the last synchronization. For a listing, see Database Error Messages.
upload_ok Set to true if the upload was successful; false otherwise.
ignored_rows Set to true if uploaded rows were ignored; false otherwise.
auth_status The synchronization authentication status. For more information, see auth_status parameter.
auth_value The value used by the MobiLink synchronization server to determine the auth_status result. For more information, see auth_value synchronization parameter.
timestamp The time and date of the last synchronization.
status The status information used by the observer function. For more information, see observer synchronization parameter.
The function returns a Boolean value.
true Success.
false Failure.
The following code checks for success of the previous synchronization.
ul_synch_result synch_result;
memset( &synch_result, 0, sizeof( ul_synch_result ) );
db_init( &sqlca );
EXEC SQL CONNECT "dba" IDENTIFIED BY "sql";
if( !ULGetSynchResult( &sqlca, &synch_result ) ) {
prMsg( "ULGetSynchResult failed" );
}