building my db with InnoDB, relations, constraints.
tbl_relations: (id, name, address)
tbl_errors: (id, relation_id, errormessage)
I have a constraint onDelete 'NO ACTION' so that I can't delete the relation
when it's used in the table tbl_errors.
[code]
$relationModel = new RelationModel();
$relationModel->delete('id=15');
[/code]
but I can't figure out what kind of error the delete is returning now. So I
can show a decend message to my users when they are trying to delete a
relation.
Someone an idea, maybe there is already somewhere/someone who builded code
to do the error followup?
-----
visit my website at http://www.phpscriptor.com/ http://www.phpscriptor.com/
--
View this message in context: http://www.nabble.com/constriants%3A-delete-%28NO-ACTION%29-tp20934833p20934833.html
Sent from the Zend DB mailing list archive at Nabble.com.
没有评论:
发表评论