UpdateBatch到底是怎么用的？（解决就结，在线）

[caimomo2002]

我是这样用的，会报错---无法为更新定位行！
void __fastcall TForm1::Button1Click(TObject *Sender)
{

ADOQuery1->Insert();
ADOQuery1->FieldByName ("computerID")->Value =i;
ADOQuery1->FieldByName ("ConsumableNum")->Value=i;
ADOQuery1->FieldByName ("OrderTime")->Value=Now();
ADOQuery1->FieldByName ("ConsumableName")->Value=i;
ADOQuery1->FieldByName ("ConsumablePrice")->Value=i;
ADOQuery1->FieldByName ("CompartmentUseID")->Value=i;
ADOQuery1->FieldByName ("ConsumableID")->Value=i;
ADOQuery1->FieldByName ("NotConfirmed")->Value=0;
ADOQuery1->FieldByName ("IsPresent")->Value=0;
ADOQuery1->FieldByName ("Remark")->Value=" ";
ADOQuery1->FieldByName ("UserID")->Value=-1;
}
//---------------------------------------------------------------------------

void __fastcall TForm1::Button2Click(TObject *Sender)
{
ADOQuery1->UpdateBatch (arAll);
}

[fall1979]

要使用ADOQuery的UpdateBatch函数，必须将ADOQuery的LockType属性设置成ltBatchOptimistic

你试一下吧！

[myzqj]

加
void __fastcall TForm1::ADOQuery1AfterPost(TDataSet *DataSet)
{
ADOQuery1->Refrresh();
}
试下，祝你好远!