By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,504 Members | 1,410 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,504 IT Pros & Developers. It's quick & easy.

Odd datatype problem when using ADODB recordset

P: n/a
Hello gurus.

I have a function that queries our mainframe using an ADODB ODBC
connection via a SELECT database.

One of the fields is Premium. When I query this data via something
like query anayler or MSquery, the data value read $6,690.00 for
example.

However, the access recordset value - for that same record - is
reading something like 6.69 - obviously a huge difference.

Note that I am not putting this value in a variable. I am simply
doing a debug.Print rs(1) statement and getting that odd value.

I would think the recordset value straightup should equal the value
when I query using other tools?

Hope that makes sense.

Thanks
Brian

Jul 19 '07 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.