It seems that the stored type in the database of a field NUMERIC(18,2) is BIGINT, of a field NUMERIC(5,2) is SMALLINT (see The FireBird Book from Helen Borrie page 127) which both give the EConvertError in RzDBEdit.pas procedure TRzDBNumericEdit.DataChanged line 2464
- Code: Select all
Value := DataLink.Field.AsFloat;
But even if I declare a field NUMERIC(10,2) which is stored as an INTEGER gives an EConvertError ("?' is not a valid floating point vallue') except when the value in the field is null.