Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Categories

call update stored procedure

I have an update stored procedure to update 19 columns and when I run it in my VB program I get the run time error :
-2147217900[microsft][odbc sql server driver][sql server]Line1: incorrect syntax nera '12345'.

adoConnection.Execute "TEST_UPDATE('" & Text1.Text & "','" & Text2.Text & "','" & Text3.Text & "','" & Text4.Text & "','" & Text5.Text & "','" & Text6.Text & "')"

I tested the other stored procedure using a six column table it worked ok. Now what am I doing wrong.

Thank you.
Help urgently needed.
Sign In or Register to comment.