How can a delete rows from a table that has foreign key constraints?
Here is how I have it set up.
I have 2 tables, tableA has fields and id's and tableB has fields that
reference tableA's id's. I'm not able to do this
BEGIN TRANSACTION;
DELETE FROM tableB
WHERE tableAid = 5;
DELETE FROM tableA
WHERE id = 5;
COMMIT TRANSATION;
Even though I delete everything from tableB that references tableA, I
can't delete the field from tableA.
Is this because of the begin and commit? Do I need to commit after each delete?
The only problem with commiting after each is, if one fails for some
reason, I need it to rollback.
-Josh