| Query inside transaction |
(01-19-2018, 11:10 PM)wishmaster Wrote: 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. I understand that you want to ignore errors due to a FK constraint. There is no way for errors inside a transaction to be ignored. What is not clear is if you want to delete the row(s) in the FK related table(s) so that the primary row can be deleted without error. I also don't understand what "delete rows in the second row only" means. What is "the second row"? |
| 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
|
