dbTalk Databases Forums  

Getting past ODBC error

comp.databases.btrieve comp.databases.btrieve


Discuss Getting past ODBC error in the comp.databases.btrieve forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
John C. Frickson
 
Posts: n/a

Default Getting past ODBC error - 05-15-2006 , 04:28 PM






While reading from a table using ODBC, I get a "Numeric value out of
range" error. At that point, I can't read any more records. Is there any
way I can get past this error and continue reading?

Thanks!
jcf

Reply With Quote
  #2  
Old   
Bill Bach
 
Posts: n/a

Default Re: Getting past ODBC error - 05-17-2006 , 12:04 PM






This message should be returned with a Status code from the ODBC driver
of SQL_SUCCESS_WITH_INFO. If you get this, just loop & process the
next record, just as if you received a SQL_SUCCESS status code.

Of course, if you can find the source of the problem and correct it,
this could be a simple indicator of bad data. Locate the bad record
and fix the data field that is out of range.
Goldstar Software Inc.
Pervasive-based Products, Training & Services
Bill Bach
BillBach (AT) goldstarsoftware (DOT) com
http://www.goldstarsoftware.com
*** Chicago: Pervasive Service & Support Class - 07/2006 ***


John C. Frickson wrote:

Quote:
While reading from a table using ODBC, I get a "Numeric value out of
range" error. At that point, I can't read any more records. Is there
any way I can get past this error and continue reading?

Thanks!
jcf


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.