Skip to main content

SetIfEmpty

procedure SetIfEmpty(aNewValue: Variant)

Example​

procedure ScriptEvent(var Value: variant);
begin
  Field.SetIfEmpty('UNKNOWN');
  Value := Field.Value;
end;

Usage​

SetIfEmpty assigns a replacement only when the field's converted string value is empty after trimming.

Additional Technical Info​

SetIfEmpty assigns aNewValue through the inherited Variant Value property only when Trim(GetAsString) = ''.

The condition is exactly the same as IsNullEmpty: database null, empty string and whitespace-only converted text qualify. Numeric zero, Boolean false and date/time zero normally do not qualify because they format as nonempty text.

The replacement Variant is not converted until assignment. Its compatibility is determined by the actual field class. Assignment can require edit/insert state, invoke validation/conversion/events, mark the record modified or raise because the field is read-only/calculated/inactive. The method neither posts nor commits.

If the condition is false, it is a no-op and does not evaluate a different fallback. Formatting/custom OnGetText behavior can affect the initial string test or raise before assignment.

Use SetIfNull when only Variant Null/Empty/Clear should qualify, or SetIfZero for Velox's numeric/date zero sentinel rule.

External references

Created 2026-07-15