Re: SQLGetData/NUMERIC field in MS Access database

Tech-Archive recommends: Fix windows errors by optimizing your registry

*********
"Bob Hairgrove" <NoSpamPlease@xxxxxxxx> wrote in message
It's possible that SQL_DECIMAL behaves differently than SQL_NUMERIC
... did you try it?

I didn't, because I would expect that according to the standard if you ask
ODBC driver to convert the data you should either get them back or you must
receive an error code, indicating that the given conversion is not possible.
In this particular case, you get wrong data and no error.

Now I tried, SQLGetData(... SQL_DECIMAL ...) returned -1. On the one hand,
the column is defined as decimal (in the database), the odbc driver returns
the type of this column as SQL_NUMERIC. So, all aforementioned conversions
must work, but they don't.

best,
Dmitry


.