Home › Forum › Integrating PerfectForms › problem writing to sql tables
Tagged: Error converting data type varchar to numeric.
This topic contains 2 replies, has 0 voices, and was last updated by Anonymous 10 years, 8 months ago.
I am trying to use a connection to write to Microsoft Dynamics NAV, and when the connection tries to insert data, I get the following error:
An error has occurred
Agent SQL error
Error converting data type varchar to numeric.
This occurs even when I am trying to send data to a field of data type “text”, so I dont understand what is being converted to numeric. Any suggestions?
The data coming from the form is varchar and you are inserting into a numeric column.
Change the receiving column datatype or use a stored procedure to take care of the conversion.
You must be logged in to reply to this topic.