The Deleted Rows tab of the MobiLink Synchronization property sheet has the following component:
Deleted row handling There are several options for managing rows that are deleted from the consolidated database:
Never download deletions Operations that delete rows from this table are not downloaded to the UltraLite database.
Truncate and reload remote table The entire table is deleted in the UltraLite database, and is refilled with all the rows currently in the consolidated database (subject to any row partitioning).
Download deletions There are two options for this choice:
You can create a shadow table that holds primary key values for rows to be deleted at the UltraLite database.
You can choose to add a column named inActive to the table at the consolidated database. This column holds a value that marks the row as inactive.
A disadvantage of this option is that any other application using the consolidated database must be sure to check if a row is inactive in queries from the table.
For more information about this property sheet and setting up synchronization scripts, see .