Stacking Transactions

Classic Servoy
1

Is it possible to “stack” transactions

situation:
user clicks edit
I start a transaction & open the selected record in a dialog (showformdialog)
The OK button that closes the dialog box, commits the transaction, the cancel rolls back
So far so good, working perfectly
Now inside this dialog I have added a tabform with related records which I can edit I the same window
This editing I would like to do in a separate transaction which I can commit or rollback when the user clicks on the appropriate button and I return to the first form in the dialog

So is it possible to stack the transaction, or do I need to find another way?

Hope this makes any sence
:roll:

2

Odysseus,

Here’s the good news - you don’t need to “stack” transactions. A single transaction can cross multiple tables/forms.

When you rollback the transaction - it rolls back in the tabpanel as well.

Give it a try! :)

Bob Cusick

3

I know and that’s exactly what I don’t want to happen.

I would like to be able to start a transaction,change something to this record, without commiting open a related record (the “stacked” one), start a transaction, change something, rollback, commit the first record.

Well I suppose that won’t happen and I’ll have to look for myself wether a record is dirty and save or cancel. It just looks like a lot of work for something that could be done with “stacked” transaction.

I’m probably just to lazy 8) 8)

4

What you want is called transaction savepoints, those are not supported by all databases, so we don’t know a way yet to provide this in Servoy.

5

Keep Thinking :wink:

So for now, I’ll just have to find another way

THX