When inserting decimal value to sql database get error there are fewer column in insert statement than values.I checked.When I insert text with this statement dont get any error.Only with decimal.may be decimal comma adds more values?for example : 5,20 in this decimal 5 is one value and 20 is another ?Help please.
Thanks in advance.
Javeed M ShaikhPosted Apr 4, 2013, 4:29 PM
Posted Apr 4, 2013, 3:47 PM
My sql statement is : INSERT INTO MY_TABLE (FIELD1,FIELD2) VALUES (1,2,2) .Here 2,2 is my decimal value.So,i get error.it is imposible add as 2.2 because in sql datatable FIELD2 datatype is DECIMAL.
THANKS
Anurag SarkarPosted Apr 4, 2013, 3:42 PM
Javeed M ShaikhPosted Apr 4, 2013, 3:14 PM
Please post your insert statement with values and the table structure with datatype and length.