Hello,
If you turn on error handling within the action by logging out any error, do you get anything that is going unnoticed?
I am getting the error Incorrect syntax near 'sql'.
insert into Requests.dbo.Req(ReqNo,Title) values ({ItemProperty:Title},{ItemProperty:Request_x0020_No})
This is my query, is there any mistake in this query?
Please help me.
don't you have swapped columns? they doesn't seems to follow naming of table columns. you might hit incorrect datatypes problem.
Yes that mistake I noticed and changed.
Now i am trying to insert only one column
insert into Requests.dbo.Req(Title) values({ItemProperty:Title});
but here i am getting an invalid column 'Test Title' error.
'Test Title' is the Title name entered from form.
I would say apostrophes are missing
insert into Requests.dbo.Req(Title) values("{ItemProperty:Title}");
Yes. Its Missing Single Quotes not double quotes. Thanks for the clue
This is what I would've suggested, but you guys beat me to it. Good work.
Glad you solved the issue, can you please mark the answer you found most useful in helping you solve this issue correct.