Field.Value

Declaration

property Value: variant

Example

procedure OnMapEvent(var Value:Variant);
begin
  Value := Dataset['myfield'].Value; //the value of myfield is returned as a Variant
end;

Description

Returns the value of the Field object as a Variant (Variant). If the field is null then null will be returned.

If a field is null and you reference it using .Value then you can experience issues with Operatorsand Functions that don't accept Variants or null values. Check the Operator or Function declaration to see what data types its parameters need to be and reference the fields using Field.AsString, Field.AsInteger, Field.AsFloat, or Field.AsSQL. (Previous reference to Field.AsDateTime was incorrect and has been removed).

You can work with Variants using the Variant functions.