Forms not working with SQL Datatype

Up 0 Down	Hi, I'm having issues with DynamicForms and datatypes in SQL. In my form I have multiple textbox fields where the user enters numbers. In my database table I have the corresponding columns' data types set as decimal(5,2) but the form won't store its values to the database. However, when I change those datatypes to nvarchar, the form submits just fine and the information is stored in the database. The weird part is that the form submits fine if I change only one of the columns back to a decimal datatype. But if I change any of the other columns, the form won't store its values to the database. I need for these fields to be a numeric type because I have calculation that need to done with their values. Is there anyway to solve this issue? DNN Term: DNN aboutimprove description TextBox Term: TextBox aboutimprove description dynamic form 5.00 Term: dynamic form 5.00 aboutimprove description sql Term: sql aboutimprove description
	asked 6/19/2014 23

Up 0 Down	Hello, I would always recommend storing data as nvarchar if you have the choice. Unless it's a date, identity column, etc... So perhaps you can do a quick conversion on your token when injecting into your SQL table. ------------------------------------------------ INSERT INTO TABLE ( COLUMN1, ... ... ) VALUES ( Convert(varchar,cast('$(VALUE1)' as money),1), ... ... ) ------------------------------------------------ Let me know if this assists you in storing the data. -Ryan
	answered 6/20/2014 Rbakerink 160
	Thank you so much! This solution worked perfectly! - 6/20/2014 But now I have another problem now. The values that I did a conversion on cause the form to NOT to submit to the database when their fields in the from are left blank. However, If I add values to these fields in the form, the form submits it's values to the database just fine. - 6/20/2014

Data Springs Modules Community Questions & Answers