🚀 go-pugleaf

I'm not sure if you can do that, but if you can check for the transaction
type.I thing it should not be Isolated or something like this, try with
ReadUncommited or any other type

Cem Uzunlar <turing@anet.net.tr> wrote in message news:3aa789a6_2@dnews...
> C1 and C2 are ADOConnection objects
> Q2 and Q2 are ADOQuery objects
>
> Following code raises and exception when second record tries to do
> updatebatch. If we dont use transactions, the problem goes away.
>
> How can we solve this problem?
>
> Thanks.
>
>     C1->Open();
>     C2->Open();
>
>     C1->BeginTrans();
>     C2->BeginTrans();
>
>     Q1->Open();
>     Q2->Open();
>
>     Q1->Append();
>     Q1->FieldByName("A1")->AsFloat = 5000;
>     Q1->UpdateBatch( arCurrent );
>
>     Q2->Append();
>     Q2->FieldByName("A1")->AsFloat = 6000;
>     Q2->UpdateBatch( arCurrent );
>
>     C1->CommitTrans();
>     C2->CommitTrans();
>
>
>