cancel
Showing results for 
Search instead for 
Did you mean: 

E-Form saving decimal as int in the database

Adrian_McAuley
Champ in-the-making
Champ in-the-making

Hi,

I have an e-form that is saving a 10 digit number to a keyword.  The keyword is setup as Numeric (Up to 20 Digits)  stored as decimal(20,0) in the Database.  When I try to save the e-form, I get an error saying 'The conversion of the varchar value '...' overflowed an int column".  I see that an integer can't be larger than 2,147,483,647 and the number I am entering is.  Shouldn't the Numeric (Up to 20 digits) setting allow me to save any 10 digit number?   

Also, I have the same e-form setup to the same keyword in our development environment and everything is workign fine.

Do you know what might be different between both environments, or why this is happening?

Thank You,

Adrian 

0 REPLIES 0