Execute Non Query: Incorrect syntax near the keyword 'is'

Execute Non Query: Incorrect syntax near the keyword ‘is’.

@Prem_Chand1

Can you please share screenshot of your query expression here. So that we can check and help you.

Hi @Prem_Chand1 ,

Your result SQL syntax is invalid.

Try something like this:

"insert into table1 values(""" + name + value + description +""")"

image

Try logging your String query before you execute it to give you an idea what’s the actual command that will be executed.