Welcome Guest, Not a member yet? Register   Sign In
Query inside transaction
#1

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?
Reply


Messages In This Thread
Query inside transaction - by wishmaster - 01-18-2018, 07:09 AM
RE: Query inside transaction - by dave friend - 01-18-2018, 12:50 PM
RE: Query inside transaction - by wishmaster - 01-18-2018, 01:15 PM
RE: Query inside transaction - by dave friend - 01-18-2018, 01:49 PM
RE: Query inside transaction - by wishmaster - 01-19-2018, 04:29 AM
RE: Query inside transaction - by Narf - 01-19-2018, 12:28 PM
RE: Query inside transaction - by wishmaster - 01-19-2018, 11:10 PM
RE: Query inside transaction - by dave friend - 01-20-2018, 07:34 AM
RE: Query inside transaction - by wishmaster - 01-20-2018, 12:21 PM



Theme © iAndrew 2016 - Forum software by © MyBB