Restarts logging of deletes for MobiLink synchronization.
START SYNCHRONIZATION DELETE
UltraLite databases automatically track changes made to rows that need to be synchronized. UltraLite uploads these changes to the consolidated database during the next synchronization of the table that was changed. This statement allows you to temporarily restart tracking of deleted rows.
When a STOP SYNCHRONIZATION DELETE statement is executed, none of the delete operations executed on that connection are synchronized. The effect continues until a START SYNCHRONIZATION DELETE statement is executed. Repeating STOP SYNCHRONIZATION DELETE has no additional effect.
A single START SYNCHRONIZATION DELETE statement restarts the logging, regardless of the number of STOP SYNCHRONIZATION DELETE statements preceding it.
Do not use START SYNCHRONIZATION DELETE if your application does not synchronize data.
The way in which UltraLite traces row states is unique. Be sure you understand the implication of deletes and row states. See UltraLite row states.
The following sequence of SQL statements illustrates how to use START SYNCHRONIZATION DELETE and STOP SYNCHRONIZATION DELETE.
STOP SYNCHRONIZATION DELETE; DELETE FROM PROPOSAL WHERE last_modified < months( CURRENT TIMESTAMP, -1 ) START SYNCHRONIZATION DELETE; COMMIT;