ACCESS数据库怎么刷新这么慢?
Access数据库,Microsoft Access Driver(*.mdb), ADO访问
看如下代码:
if(update->Active)
update->Active=false;
update->SQL->Clear();
update->SQL->Add("insert into TestData(SN) values('12')");
update->ExecSQL();
Sleep(7000); //如果去掉此行,或是把时间该短,将出现no rec的对话框
if(select->Active)
select->Active=false;
select->SQL->Clear();
select->SQL->Add("select * from TestData where SN='12'");
select->Active=true;
if(select->RecordCount<=0)
ShowMessage("no rec");
为什么数据库更新的如此慢?