一下是A部分程序
str1:='insert into temptable4 select * from table4 ';
frm_main.ExecQuery(query1,str1);
A//
一下是B部分程序
str1:='delete table4 from table4 inner join temptable4 on table4.parm1=temptable4.parm1 and table4.parm10=temptable4.parm10 ';
frm_main.ExecQuery(query1,str1);
B //
frm_main.writelog(datetimetostr(now)+errorlog1); str1:='insert into temptable5 select * from table5 ';
frm_main.ExecQuery(query1,str1); str1:='delete table5 from table5 inner join temptable5 on table5.parm2=temptable5.parm2 and table5.parm4=temptable5.parm4 ';
frm_main.ExecQuery(query1,str1);
frm_main.writelog(datetimetostr(now)+errorlog2);//update table7
str1:='insert into temptable7 select * from table7 ';
frm_main.ExecQuery(query1,str1); str1:='delete table7 from table7 inner join temptable7 on table7.parm2=temptable7.parm2 and table7.parm1=temptable7.parm1 ';
frm_main.ExecQuery(query1,str1);
对于以上的语句,我想使在A程序完成执行后然后在执行B部分,因为之间有一个顺序的问题,所以如何做到上述要求?
str1:='insert into temptable4 select * from table4 ';
frm_main.ExecQuery(query1,str1);
A//
一下是B部分程序
str1:='delete table4 from table4 inner join temptable4 on table4.parm1=temptable4.parm1 and table4.parm10=temptable4.parm10 ';
frm_main.ExecQuery(query1,str1);
B //
frm_main.writelog(datetimetostr(now)+errorlog1); str1:='insert into temptable5 select * from table5 ';
frm_main.ExecQuery(query1,str1); str1:='delete table5 from table5 inner join temptable5 on table5.parm2=temptable5.parm2 and table5.parm4=temptable5.parm4 ';
frm_main.ExecQuery(query1,str1);
frm_main.writelog(datetimetostr(now)+errorlog2);//update table7
str1:='insert into temptable7 select * from table7 ';
frm_main.ExecQuery(query1,str1); str1:='delete table7 from table7 inner join temptable7 on table7.parm2=temptable7.parm2 and table7.parm1=temptable7.parm1 ';
frm_main.ExecQuery(query1,str1);
对于以上的语句,我想使在A程序完成执行后然后在执行B部分,因为之间有一个顺序的问题,所以如何做到上述要求?
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货