01-18-2018, 07:09 AM
Hi, guys.
I have transaction which delete rows in multiple queries.
$this->db->trans_begin()
...
Here I need a query that trying delete some rows and if the operation of delete this rows would be with error due to FK constraint, just goes to the next query without aborting (rolling back) the base transaction.
....
others queries
......
$this->db->trans_complete()
Any ideas?
I have transaction which delete rows in multiple queries.
$this->db->trans_begin()
...
Here I need a query that trying delete some rows and if the operation of delete this rows would be with error due to FK constraint, just goes to the next query without aborting (rolling back) the base transaction.
....
others queries
......
$this->db->trans_complete()
Any ideas?