Subforms and transactions

[Sergey Bogdanov]

Hello,

I have a form where I've created own Recordset and attach it to this form
and "BeginTrans". Everything worked fine till I didn't add Subform to this
form. I can't start BeginTrans for this subform.
is it possible to start transaction for subform and for main form in the
same time?

And there is another question -- is it possible to pass Recordset to an
newly opened form and after some modification commit transaction.

Thnx in advance,
Sergey

 

[Allen Browne]

Are you trying to create a transaction around a bound form and its subform,
so you can roll back all changes to both? If so, no, I don't believe it is
possible to do that.

I'd love for you to prove me wrong, but I have not been able to achieve
that, and neither have I found anyone who has. The less-than-optimal
workaround is to use a temp table for the edits/deletes/inserts, and only
commit them to the real table later.

 

[Allen Browne]

Are you trying to create a transaction around a bound form and its subform,
so you can roll back all changes to both? If so, no, I don't believe it is
possible to do that.

I'd love for you to prove me wrong, but I have not been able to achieve
that, and neither have I found anyone who has. The less-than-optimal
workaround is to use a temp table for the edits/deletes/inserts, and only
commit them to the real table later.