10,730
edits
Important: Deprecating old WebView — Publish failed error
Synchronization steps: Difference between revisions
Jump to navigation
Jump to search
→RowVersion versus LastSyncDate
| Line 271: | Line 271: | ||
== RowVersion versus LastSyncDate == | == RowVersion versus LastSyncDate == | ||
Database tables often have a hidden column RowID - unless the database admin explicitly requested that this column is not created. | Database tables often have a hidden column RowID - unless the database admin explicitly requested that this column is not created. For each database operation, this column is filled from the global database counter: | ||
For each database operation, this column is filled from the global database counter: | |||
<code>table.RowID = ++GlobalRowID</code> | <code>table.RowID = ++GlobalRowID</code> | ||
| Line 290: | Line 288: | ||
we store the current date and time instead. This is less exact, but good enough. | we store the current date and time instead. This is less exact, but good enough. | ||
We store these values in <code>rs_sync2</code> table (one row per table). The table is updated after the table download successfully completes. | We store these values in the <code>rs_sync2</code> table (one row per table). The table is updated after the table download successfully completes. | ||
<pre> | <pre> | ||
[rs_sync2] | [rs_sync2] | ||