不能确定为何
try:
ADOQuery2->SQL->Clear() ;
ADOQuery2->SQL->Add("truncate table 表1");
ADOTable2->Active=true;
ADOQuery2->Active=true;
ADOQuery2->ExecSQL();
try:
ADOQuery2->SQL->Clear() ;
ADOQuery2->SQL->Add("truncate table 表1");
ADOTable2->Active=true;
ADOQuery2->Active=true;
ADOQuery2->ExecSQL();
如果是清空该表,建议用truncate table(不写日志,快)
ADOQuery2->SQL->Add("delete from 表1 ");
ADOTable2->Active=true;
ADOQuery2->Active=true;
ADOQuery2->CommandTimeout=0;
ADOQuery2->ExecSQL();