At 08:00 PM 01-04-01 +0200, you wrote:

>Hello,
>
> 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:
try

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

Helen

All for Open and Open for All
InterBase Developer Initiative · http://www.interbase2000.org
_______________________________________________________