| Query inside transaction |
There is one table and ID from this one may be in ONE or MORE rows in the second table (FK relationship). So if I delete row in the second table, this operation will delete rows from either both tables or error occur. Therefore I need situation where each delete operation finishes without error, just either delete if possible or bypass error (due to FK constraint) and delete rows in the second row only.
|
| 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
|
