Subject | Problem with numerics |
---|---|
Author | Pascal Amesland |
Post date | 2001-04-01T18:00:12Z |
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 !!!
Here is the query (in IBOQuery)-:
select
ADHERENT
, nom
, prenom
, CODEACT
, ORG
, CODE
, ( select libCourt from libOrg
where liborg.code=esfffsadh.org
) as LibOrg
, ( select libelle from esfffs
where esfffs.org=esfffsadh.org
and esfffs.code=esfffsadh.code
) as libCode
, esfffsadh.DATETEST
,cast( esfffsadh.TEMPS as numeric) as temps <---
,cast( esfffsadh.points as numeric) as pts <---
,cast( esfffsadh.MINUTES as numeric) as minutes <---
from adh, esfffsadh
where esfffsadh.adherent=adh.nomembre
order by code, points, minutes desc, temps desc
Help please...
Best regards,
Pascal Amesland - PA Soft
p.amesland@...
______________________________________
____ ___ _____ ______
/ __ \/ | / ___/____ / __/ /_
/ /_/ / /| | \__ \/ __ \/ /_/ __/
/ ____/ ___ | ___/ / /_/ / __/ /_
/_/ /_/ |_| /____/\____/_/ \__/
______________________________________
Tel: 03 89 60 52 21
Fax: 03 89 43 78 99
35 rue sainte Therese
68200 MULHOUSE
FRANCE
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 !!!
Here is the query (in IBOQuery)-:
select
ADHERENT
, nom
, prenom
, CODEACT
, ORG
, CODE
, ( select libCourt from libOrg
where liborg.code=esfffsadh.org
) as LibOrg
, ( select libelle from esfffs
where esfffs.org=esfffsadh.org
and esfffs.code=esfffsadh.code
) as libCode
, esfffsadh.DATETEST
,cast( esfffsadh.TEMPS as numeric) as temps <---
,cast( esfffsadh.points as numeric) as pts <---
,cast( esfffsadh.MINUTES as numeric) as minutes <---
from adh, esfffsadh
where esfffsadh.adherent=adh.nomembre
order by code, points, minutes desc, temps desc
Help please...
Best regards,
Pascal Amesland - PA Soft
p.amesland@...
______________________________________
____ ___ _____ ______
/ __ \/ | / ___/____ / __/ /_
/ /_/ / /| | \__ \/ __ \/ /_/ __/
/ ____/ ___ | ___/ / /_/ / __/ /_
/_/ /_/ |_| /____/\____/_/ \__/
______________________________________
Tel: 03 89 60 52 21
Fax: 03 89 43 78 99
35 rue sainte Therese
68200 MULHOUSE
FRANCE