How to Using Multiple SQL Statements in an SQL Action of Application Engine
/*– Use ; –*/
SQL Statment 1
%Execute()
Update TABLE1 Set Status=’A’;
Update TABLE1 Set Status=’B’;
Update TABLE2 Set Status=’C’;
SQL Statment 2
%Execute()
Update TABLE1 Set Status=’A’;
Delete TABLE1 where Status=’B’;
insert into TABLE2 values(‘1′,’C’);
/*– Use / –*/
SQL Statment 3
%Execute(/)
Update TABLE1 Set Status=’A’/
Update TABLE1 Set Status=’B’/
Update TABLE2 Set Status=’C’/
SQL Statment 4
%Execute(/)
Update TABLE1 Set Status=’A’/
Delete TABLE1 where Status=’B’/
insert into TABLE2 values(‘1′,’C’)/