Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

ODBC Connections Expand / Collapse
Author
Message
Posted Monday, May 26, 2014 3:07 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, June 12, 2014 2:15 AM
Points: 18, Visits: 43
I have a CRF which I have changed the version by adding few variables. I made all the necessary changes to the form and database. I am using what we call Teleform system for data management. I have managed to commit data of the new version to the database. However, the subsequent forms are giving me this error:
[Microsoft][ODBC SQL Server Driver] Numeric value out of range (V10.7 10705) Failed committing batch.

I have tried to check which values on the CRFs are out of range but I can not find one.

Any help on how I can deal with this error
Post #1574488
Posted Wednesday, June 4, 2014 3:22 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Today @ 2:58 AM
Points: 61, Visits: 529
Hi,

I suspect you have a non numeric character in a column which you are trying to populate a column which is numeric datatype. if the column in the source data is a float try casting as a numeric prior to exporting.


============================================================
David

http://www.sqlservercentral.com/articles/Best+Practices/61537/
Post #1577246
Posted Wednesday, June 11, 2014 6:27 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, June 12, 2014 2:15 AM
Points: 18, Visits: 43
Thanks David. I have identified the field which was bringing this error and I have resolved.
Post #1579590
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse