Page 1 of 1

Type numeric mapping wrong

Posted: Mon 06 Jul 2009 14:09
by Claudio
dbexppgsql.dll = 1.0.0.4
DELPHI 7
ENABLE BCD = TRUE

--------------------------------
select cast(0 as numeric) as tpnumeric; <----- mapping (FLOAT)

select cast(0 as numeric(10,2)) as tpnumeric; <----- mapping (FMTBCD)

----------------------------

is this a BUG ?

Posted: Wed 12 Aug 2009 09:07
by Plash
This is designed behaviour. But in the next build of the driver we will change this behaviour to use TFMTBCDField for numeric fieds without precision.