Possible use of mysql rollback?

[slobodan]

Is it possible to rollback last save(update), using AS(after save) php code?

[kev1n]

Can't you use the BS event to prevent the saving in the first place?

To rollback a saving operation you'd have to retrieve the values that are stored in the table in BS, store their values in a session variable and then UPDATE your record with the old values in AS.

[slobodan]

The idea is to consistently perform all related updates on the database or, if any of that gets stuck, to restore the database to its previous state. If this cannot be done in the same dbase transaction, the closest option is your suggestion. So, if mysql saved procedure started in AS, did rollback, data that was updated by the form, should be returned to the state stored in BS. Is it correct?

[kev1n]

or, if any of that gets stuck, to restore the database to its previous state.

Either all data is saved or none. In which scenario would data not be fully stored ?

So, if mysql saved procedure started in AS, did rollback, data that was updated by the form, should be returned to the state stored in BS. Is it correct?

yes

[slobodan]

I used to work on an application for a manufacturing company, where dynamic part reservations were done in warehouses. On the principle of competition, where it was necessary to maintain the synchronized conditions in several accompanying tables. This was done strictly in database transactions, in order to maintain the consistency of the data. Most forms do not require such complex processing, but it is better to make an effort to learn new software, if it allows such things.
It seems to me that nuBuilder is worth the effort, although online sources of information are much rarer than for some others, such as for Oracle APEX for example. In that sense, thank you for your quick answers on this forum.

Slobodan