beas script: is it possible to execute 2 commands in an if...then clause ?
Hello,
I tried to look this up in beas script documentation but was not able to find anything.
I would like to update 2 tables using sql in beas script in 1 singe if...then clause. Is this possible? And, if yes, how do I accomplish that? How do I link the 2 sql statements following the then
see code example:
global function form_update
sql=SELECT column FROM table1 WHERE...
if=<wert1>='X' then
update table2 set udf1 =...
update table3 set udf1 =...
return true
end global
Any ideas?
Thanks in advance!
Patrick
Comments
2 comments
Hi Patrik,
use this syntax
http://help.beascloud.com/script/index.html?ifwert1operatorwert2.htm
if <wert1> = 'X' then
...
end if
Hello Martin,
that worked fine. Thank you!
Patrick
Please sign in to leave a comment.