Deferred (Property Keyword)
Usage
To specify that this property is deferred, use the following syntax:
Property name As classname [ Deferred ];
Otherwise, omit this keyword or place the word Not immediately before the keyword.
Details
A deferred property is not immediately filed when a new record is inserted or updated. Instead, the record is flagged as having deferred filing work to complete, which is accomplished by a backfilling operation at a later time.
When this keyword is specified on a computed field, queries that involve the field may only see stale information and skip rows that have not yet been filed by the backfilling operation. You should weigh the benefits that deferred filing bring to the efficiency of your application against the risk of querying stale information.
Default
The default for the Deferred keyword is false.
Requirements
The table must have a bitmap-compatible ID.
For a property to be marked as Deferred, it must have SqlComputed=1, but cannot have either Calculated=1 or Transient=1.
Properties marked as Deferred cannot be Required, part of an enforced foreign key, or constrained by a VALUELIST. In short, no validation can be performed on Deferred fields.
A trigger cannot be marked as Deferred.
