Subject | Is CURRENCY field column attributes ignored? |
---|---|
Author | Marco Menardi |
Post date | 2001-11-06T00:22:55Z |
I've a mynum NUMERIC(15,2), defined as CURRENCY in the query.
Having a look at IBA_Column.IMP i can see that when I edit that field
in a IB_Edit and exiting the value is assigned to the field, it's
called the code for a generi floating field
TIB_ColumnNumeric.SetAsString(
...
try
Value := StrToFloat( tmpVal );
except
...
so a value like 21321545000010,00 is accepted (!!! it's 16 digits+00).
But if you try to set this value to the field with
Field.AsCurrency := 21321545000010
an error occurs (welcome!)
I don't understand this situation... and what's the use of CURRENCY
column attribute?
Thanks
Marco Menardi
Having a look at IBA_Column.IMP i can see that when I edit that field
in a IB_Edit and exiting the value is assigned to the field, it's
called the code for a generi floating field
TIB_ColumnNumeric.SetAsString(
...
try
Value := StrToFloat( tmpVal );
except
...
so a value like 21321545000010,00 is accepted (!!! it's 16 digits+00).
But if you try to set this value to the field with
Field.AsCurrency := 21321545000010
an error occurs (welcome!)
I don't understand this situation... and what's the use of CURRENCY
column attribute?
Thanks
Marco Menardi