Transaction

nanangarema

When insert/update then insert to another table (or execute a sql that affect other table) .All in one transaction (atomic) . How can i do that?
Thanks.

allan

Currently, in the Editor PHP libraries, this isn't possible. The reason being is that the Editor insert / update / delete is performed in a transaction, so you would need to either remove that and then create your own transaction, or put additional code into the libraries before it commits the transaction (perhaps as a callback?).

Allan

nanangarema

Thanks for your replay. Ok, i will use database trigger before update/edit/delete for simplicity.