Subject Re: [IBO] Problem with numerics
Author Helen Borrie
At 08:00 PM 01-04-01 +0200, you wrote:
> I have fields declared as numeric(9.3) in a table.
> When i make a query, the fields appears correctly, example : 1,123
> ( , is the decimal separator).
> When i try to edit these fields with QuickReport (and TIBOQuery),
> nothing is printed (white space...).
> When i cast the fields, only the integer part does print !!!
> ,cast( esfffsadh.TEMPS as numeric) as temps <---
> ,cast( esfffsadh.points as numeric) as pts <---
> ,cast( esfffsadh.MINUTES as numeric) as minutes <---

The size and scale are missing:

cast( esfffsadh.TEMPS as numeric(9,3)) as temps


All for Open and Open for All
InterBase Developer Initiative ยท