'Could not Convert Variant of type (Null) into type (Double)'

Question

if DataModuleGeral.tbHonorariosPERCENT_ADV_ASSIST1.AsFloat = 0 then
begin
  DataModuleGeral.tbHonorariosPERCENT_ADV_ASSIST1.Value := Null;
end;

I have the above routine that when the percentage cap is 0 I try to set the field to Null so that in the database do not keep the field blank... In the Delphi 7 works perfect and now in Delphi 10.1 is not working... Does anyone know how to solve?

Answer 1

In the assignment of null I’ve had trouble using the Value, then use the AsVariant thus:

DataModuleGeral.tbHonorariosPERCENT_ADV_ASSIST1.AsVariant:= Null;