Update _All Regardless Of Base Table Changes

This field controls inclusion of the IF UPDATE(...) condition that determines whether to update the _all table associated with the base table based on which columns are being updated:

  • When this check box is selected, the IF UPDATE(...) condition is skipped. The result is that the _all table row is updated regardless of which columns of the base table row are being updated, and thus the _all table RecordDate is always a snapshot of the base table RecordDate (similar to any other _all-replicated column). This allows applications to rely on the equality of the base table RecordDate and the corresponding _all table RecordDate to imply that no changes to any columns of that row in the base table have occurred since that date.
  • When this check box is NOT selected, the IF UPDATE(...) statement prevents update of the _all table row unless an _all-replicated column is being changed in the base table row. The result is that the last date when the _all table row was touched maintains the last time any _all-replicated columns of the base table row changed. This is the normal behavior for most tables, providing best performance, when no applications directly compare the base table RecordDate and the corresponding _all table RecordDate.