>Hi ,
>
>Referential Integrity Builder
>
>Error 1539 (Insert triger failed) :
>
>Parent Child Upd Del Insert ParentTag Childtag
>----------------------------------------------------------------------------------------
>Articles OrderDetail Restrict Restrict Restrict IdArt IdArt
>Order OrderDetail Restrict Cascad Restrict IdOrder IdOrder
>
>When i chenged for Insert rules (whatever, Articles or Order), Ignore instead Restrict,thats working correct.
>Where is the problem?
>
>Please, help me!
Are you sure that you're inserting right data into the child table? E.g. does the key you're inserting exist in the parent table? If not, then the message is correct, you should not allow this to happen. If your data are correct, then there was a problem in trigger's code itself.
If it's not broken, fix it until it is.
My Blog