Wrong return from GetFieldValue() with decimal field

[warvimo]

Hi there,

I'm using MFC CRecordset to retrieve data from a Oracle Database 10g.

All is good except if a data type in database is NUMBER(x, y).
I looked into m_nSQLType of CODBCFieldInfo struct and it's correct, returning 3 (SQL_DECIMAL).

So, the function GetFieldValue(LPCTSTR lpszName, CDBVariant& varValue) returns a CDBVariant with wrong data type. He throws it as String instead of double.

I tried it with NUMBER (without precision) and it worked fine, but i need that precision.


Please, any help?


Kind Regards,
Warvimo.