我只用一个adoquery,在一次按键操作中最多执行几条sql语句
比如
with adoquery do
sql.clear;
sql.add('insert into table1(....) value (...)');
sql.add('insert into table2(....) value (...)');
sql.add('delete ... from table3 where ...')
sql.execsql可不可以运行?
比如
with adoquery do
sql.clear;
sql.add('insert into table1(....) value (...)');
sql.add('insert into table2(....) value (...)');
sql.add('delete ... from table3 where ...')
sql.execsql可不可以运行?
sql.add('insert into table1(....) value (...);');
sql.add('insert into table2(....) value (...);');
sql.add('delete ... from table3 where ...')
sql.execsql
sql.clear;
sql.add('insert into table1(....) value (...)');
sql.execsql;close;
sql.clear;
sql.add('insert into table2(....) value (...)');
sql.execsql;close;
sql.clear;
sql.add('delete ... from table3 where ...');
sql.execsql;