CAST NULL AS NUMBER(9) problem
Posted: Mon 14 Apr 2008 10:29
We are using DbexpOda.dll Version 3.2.0.9
with those parameters:
EnableBCD = False
IntegerPrecision = 9
SmallIntPrecision = 0
FloatPrecision = 38
Every NUMBER(9) fields are correctly mapped as TIntegereField.
We want to map a View with NULL value for a column and map it as Integer Field.
CREATE VIEW MYVIEW (MyField1, MyField2) AS
SELECT
CAST(NULL AS NUMBER(9)) ,
CAST(0 AS NUMBER(9))
FROM
MYTABLE
MyField1 Will be wrong mapped as TFloatField.
MyField2 Will be correctly mapped as TIntegerField.
Why?
THX
Andrea
with those parameters:
EnableBCD = False
IntegerPrecision = 9
SmallIntPrecision = 0
FloatPrecision = 38
Every NUMBER(9) fields are correctly mapped as TIntegereField.
We want to map a View with NULL value for a column and map it as Integer Field.
CREATE VIEW MYVIEW (MyField1, MyField2) AS
SELECT
CAST(NULL AS NUMBER(9)) ,
CAST(0 AS NUMBER(9))
FROM
MYTABLE
MyField1 Will be wrong mapped as TFloatField.
MyField2 Will be correctly mapped as TIntegerField.
Why?
THX
Andrea