Problem with ADO UpdateBatch
I have a problem with ADO UpdateBatch.
I use BCB5.0 with ADO update pack.
here are my codes:
ADOConnection1->BeginTrans();
strsql="select * from AreaInfo";
ADODataSet1->CursorLocation=clUseClient;
ADODataSet1->CursorType=ctStatic;
ADODataSet1->LockType=ltBatchOptimistic;
ADODataSet1->LoadFromFile(OpenDialog1->FileName);
ADODataSet1->UpdateBatch(arAll);
ADOConnection1->CommitTrans();
the UpdateBatch function does not work. why?
Could someone give me a favor?