SQL Update

Help Activities
,
1

Hello,
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

“Update Test
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.

2

Hi @luisablind96

Try writing the query in this way.

“Update Test"
“set LAGRAD = '”+City+”’"
"where Code = ‘HET’

Let me know what happens.

3

Hi @luisablind96 ,

Try:

"Update [Test] Set [LAGRAD]='"+City+"' Where Code = 'HET'"

Marius

4

Hi @Marius_Puscasu,
Thank you!!!
It works:)

5

Hi @Marius_Puscasu ,
do you know how it works when I want to update two variables?
“Update [Test] Set [LAGRAD]='”+City+“’ and [BRGRAD]='”+Value+“’ Where Code = ‘HET’”
It does not work with an “And” or my “,”.

6

Hi @luisablind96 ,

It should be something like this:

"Update [Test] Set [LAGRAD]='"+City+"', [BRGRAD]='"+Value+"' Where Code = 'HET'"

Please pay attention to the database columns. It should match the name and, the type should be compatible as well.

For a better understanding, you could also check this: https://www.w3schools.com/sql/sql_update.asp

Best regards,
Marius