我的语句:
try
ADOConnection.BeginTrans; ADOCommand.CommandText:='INSERT INTO AA SELECT * FROM BB';
ADOCommand.Execute; ADOConnection.CommitTrans;
except
ADOConnection.RollbackTrans;
end;报错:其他会话正在使用事务的上下文什么原因?谢谢!
try
ADOConnection.BeginTrans; ADOCommand.CommandText:='INSERT INTO AA SELECT * FROM BB';
ADOCommand.Execute; ADOConnection.CommitTrans;
except
ADOConnection.RollbackTrans;
end;报错:其他会话正在使用事务的上下文什么原因?谢谢!
也就是说:
在
try
ADOConnection.BeginTrans; ADOCommand.CommandText:='INSERT INTO AA SELECT * FROM BB';
ADOCommand.Execute; ADOConnection.CommitTrans;
except
ADOConnection.RollbackTrans;
end;
之前和之后都不能有类似ADOConnection.BeginTrans;的语句!
ADOConnection.CommitTrans;
不配对,你查看一下你前面是不是打开事务了。