Subject Re[2]: [IBO] Problem with numerics
Author Pascal Amesland
Hello Helen,

Thanks, it works, i already tried it, but i probably made a syntax
error at this time.

Monday, April 02, 2001, 12:45:51 AM, you wrote:

HB> 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 <---

HB> The size and scale are missing:
HB> try

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

HB> Helen

HB> All for Open and Open for All
HB> InterBase Developer Initiative ยท
HB> _______________________________________________________

HB> Your use of Yahoo! Groups is subject to

Best regards,
Pascal mailto:p.amesland@...