beas script: is it possible to execute 2 commands in an if...then clause ?

Patrick Herr

• September 22, 2021 08:04
• Edited

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

Vote

0

• 

  Martin Heigl

  • September 22, 2021 09:45

  Hi Patrik,

  use this syntax

  http://help.beascloud.com/script/index.html?ifwert1operatorwert2.htm

  if <wert1> = 'X' then
  ...
  end if

   

   
• 

  Patrick Herr

  • September 22, 2021 13:40

  Hello Martin,

  that worked fine. Thank you!

  
  Patrick

Please sign in to leave a comment.