odbc call failed with null numeric fields

P

Pete

I have some simple VBA code that accesses data from an Oracle database. I
use an OpenConnection statement with SQL to pull this data. It works fine
for text fields and numeric fields that have data. But, if a numeric field
has any null values, I get an ODBC Call Failed error. Any ideas why this
would happen?

Thanks,

Peter
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

ODBC error 100 when accessing Bookkeeper version 15 software (accounting software using Access dbase) 0
Page numbering with Merged Document and IF statements 1
ODBC--Call failed. 4
Some mail merge fields not pulling into document 2
Access Project SQL Import csv 4
ODBC setup 2
Text feild check for pattern or if last 5 are numeric? 1
ODBC--call failed. 3

Top