problem writing to sql tables

Home Forum Integrating PerfectForms problem writing to sql tables

This topic contains 2 replies, has 0 voices, and was last updated by  Anonymous 11 years, 1 month ago.

Viewing 3 posts - 1 through 3 (of 3 total)
  • Author
  • #555



    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.

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic.