How to Using Multiple SQL Statements in an SQL Action of Application Engine

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’)/

Posted in Application Engine (AE), SQL.