Norman Dunbar <Norman.Dunbar_at_lfs.co.uk> wrote in message news:<E2F6A70FE45242488C865C3BC1245DA7038F883A_at_lnewton.leeds.lfs.co.uk>...
> Morning,
>
> you MUST use :OLD in a delete trigger and not :NEW. If you use :NEW then
> you get the message that n rows have been deleted, but they have not.
> Change the trigger to the following :
>
> ELSIF DELETING THEN
> DELETE FROM contractorsMV
> WHERE conIDMV = :OLD.conID;
>
> DELETE FROM contractors
> WHERE conID = :OLD.conID;
>
>
> Cheers,
> Norm.
>
> -------------------------------------
> Norman Dunbar
> Database/Unix administrator
> Lynx Financial Systems Ltd.
> mailto:Norman.Dunbar_at_LFS.co.uk
> Tel: 0113 289 6265
> Fax: 0113 289 3146
> URL: http://www.Lynx-FS.com
> -------------------------------------
Hello All,
Thank you for your insight to my little issue.
I changed the .new to .old.
Rows successfully deleted via the trigger.
Thanks again for you assistance.
Alex-
Received on Wed Apr 16 2003 - 17:25:24 CDT
