Hi experts,
I am going to ask an pretty old question. Though I researched everywhere I could not figure out a solution and I strongly believe you can help. I am trying to use sql insert into statement to update a table with form data. But when I break the code into multiple lines I am getting some error. Here is the code.
Getting error as 3134 syntax error in insert into statement
Where am I going wrong.
I am going to ask an pretty old question. Though I researched everywhere I could not figure out a solution and I strongly believe you can help. I am trying to use sql insert into statement to update a table with form data. But when I break the code into multiple lines I am getting some error. Here is the code.
Code:
Dim updsql as string
updsql = “ insert into tasks [received],[sender],[sent at] _
& “[employee],[department] _
& “ values (‘“ & me.rvd & “‘),(‘“ & me.snd & “‘),(‘“ & me.sntat & “‘)” _
& “(‘“ & me.emp & “‘),(‘“ & me.dpt & “‘));)
Getting error as 3134 syntax error in insert into statement
Where am I going wrong.
Last edited: