The Row Increment tab of the MobiLink Synchronization property sheet has the following component:
Download increment Specify a method to select the rows that are downloaded to this table.
Snapshot In a snapshot download, all rows of the table on the consolidated database are downloaded to the UltraLite database at each synchronization, whether or not they have changed.
Timestamp In a timestamp-based download, only those rows that have changed since the last download are downloaded.
This choice requires that the timestamp values be stored somewhere. You can choose to use a shadow table to store these values. If you check the box to use a shadow table, a table with the suffix _updated is created in the consolidated database, to hold the primary key values and a timestamp indicating when the row was last updated.
If you do not use a shadow table, an additional column is added to the table and holds the time that the row was last updated as a timestamp.
Sequence number In a sequence-based download, you need to specify a column and an expression. For each row, the value in the specified column is compared to the value of the expression you provide. Only rows for which the column value is greater than the expression are downloaded.
Custom SQL expression Advanced users can specify a custom SQL expression that is evaluated for each row. Only rows for which the expression is true are downloaded.
For more information on these synchronization techniques, see .
For more information about this property sheet and setting up synchronization scripts, see .