ADO_BatchUpdate本地编辑模式,是在客户端修改好几笔数据后才一次过更新回数据源,中途可以取消修改。
要进入BatchUpdate模式要进行以下设置,以ADODataset数据集为例:
//属性设置
with ADODataset1 do
begin
CursorType := KeySet; //or Static
LockType := BatchOptimistic;
Cursorlocation := clUseClient;
end;
//执行更新
ADODataset1.UpdateBatch;
//取消更新
ADODataSet1.CancelBatch;
with ADODataset1 do
begin
CursorType := KeySet; //or Static
LockType := BatchOptimistic;
Cursorlocation := clUseClient;
end;
//执行更新
ADODataset1.UpdateBatch;
//取消更新
ADODataSet1.CancelBatch;