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 8 years, 3 months ago.

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

    Anonymous

    Hi,

    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?

    #5435

    The data coming from the form is varchar and you are inserting into a numeric column.

    #5436

    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.