DataTables
Advanced interaction
features for your tables.
Editor
Comprehensive editing
library for DataTables.
Manual
Download
≡ Show site navigation

Transaction

Transaction

nanangaremananangarema Posts: 7Questions: 2Answers: 0
edited December 2013 in Editor
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.

Replies

  • allanallan Posts: 64,324Questions: 1Answers: 10,622 Site admin
    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
  • nanangaremananangarema Posts: 7Questions: 2Answers: 0
    Thanks for your replay. Ok, i will use database trigger before update/edit/delete for simplicity.
This discussion has been closed.

DataTables

DataTables designed and created by SpryMedia Ltd.
© 2007-2023 MIT licensed. Privacy policy. Supporters.
SpryMedia Ltd is registered in Scotland, company no. SC456502.