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.

[Vanaj]

have you tried using SQL_C_DOUBLE as the third param in the function call ???


GetFieldValue(lpszName, varValue, SQL_C_DOUBLE)

[warvimo]

Hey,

No, i didn't tried this yet.
But is it required? I mean, force a cast to double.
I will test it and reply.


Thanks for answering.

[warvimo]

Hey Vanaj!

It worked!
Thanks so much.

I found out in sql defines DECIMAL, NUMERIC and VARCHAR is treated similarly...weird.


Thanks again,
Warvimo.

[Vanaj]

Glad to help...sometimes you need to force values to what you need and not use the default and assume it will be correct...

void GetFieldValue( LPCTSTR lpszName, CDBVariant& varValue, short nFieldType = DEFAULT_FIELD_TYPE );