Re: Conditional Trigger

From: <mowinom_at_hotmail.com>
Date: Wed, 28 Nov 2007 04:09:13 -0800 (PST)
Message-ID: <ab7853b6-4549-400d-96ff-6f4d3661e3c0@a35g2000prf.googlegroups.com>

Hi All,

I solved the puzzle buy using two cursors. One cursor fetched all records that equaled :New.ISBN and the other fetched records in the periodical# column that equaled :New.periodical#_Owner.

After that, I used a conditional check to ensure that if the ISBN being entered in the table already existed then periodical#_Owner was to be provided and that it had to be equal an existing periodical#.

The trigger is working fine and I'm happy with it. Thanks to you all for your suggestions and helpful criticism; special thanks to David and Daniel.

Regards,
Mark Received on Wed Nov 28 2007 - 06:09:13 CST