I would like to update a database via SQL. For this I have chosen the activity “Execute Non Query”.
Now I have tried the following command
set LAGRAD = '”+City+"’
where Code = ‘HET’ "
City is a variable I created of the type “String”. If I set a number like for example a 1 the update is done. But if I insert the variable this does not work.
Does this have something to do with the variable type or is the SQL command incorrect?
I hope you can help me.