I am running simple insert query and getting syntax error:
"Insert into [dbo_check_outstanding][(PS CASE)] values (“123456”) ; "
Error getting:
Insert: Syntax error (missing operator) in query expression ‘PS CASE’.
Can anyone pls suggest what i am doing incorrectly .
Thanks in Advance !!
Hi @mittal.abhishek066
No need to mention this Square braket .
Just write the Expression like this inside the quotes.
"Insert into dbo_check_outstanding (PS CASE) VALUES ('123456') ;"
thanks
VP
Thanks for sharing solution but getting error:
Insert: The SELECT statement includes a reserved word or an argument name that is misspelled or missing, or the punctuation is incorrect.
@mittal.abhishek066
Have u tried without punctuation and run the query
"INSERT INTO dbo_check_outstanding (PS CASE) VALUES ('123456') "
if the column is of type number then try without quotes for value
Regards
No , i have tried in a same way as u given to me.
“Insert into dbo_check_outstanding (PS CASE) VALUES (‘123456’) ;”
@LAKSHMI_NARAYANA_PEMMASAN - Same issue occuring after removing the quotes
can you show what activity you are using and how you have give the query
try with square brackets for column name
Regards
i guess there are some clarifications needed
As per your initially you are just insert a record but using insert activity which is for datatable insert
is you table has only one column ? if not then you have to pass blank values for the rest
Can you please go through the below tutorial , you get an idea
https://www.youtube.com/playlist?list=PL41Y-9S9wmyLAVPs4oS8t0QlGAC8cIVXF
Regards
@mittal.abhishek066
Can U try this Expression with : Run query activity