2008年12月10日星期三

[fw-db] constriants: delete (NO ACTION)

Hello,

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.

没有评论: