Subject | Re[2]: [IBO] Problem with numerics |
---|---|
Author | Pascal Amesland |
Post date | 2001-04-02T05:20:43Z |
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:
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 ยท http://www.interbase2000.org
HB> _______________________________________________________
HB> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
--
Best regards,
Pascal mailto:p.amesland@...
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:
>>Hello,HB> The size and scale are missing:
>>
>> 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> 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 ยท http://www.interbase2000.org
HB> _______________________________________________________
HB> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
--
Best regards,
Pascal mailto:p.amesland@...