mutating

Question posted by: casperovo (Newbie) on August 29th, 2008 07:03 AM

Dear all,
i have a table called sundry_items_reply on which i am doing a trigger after insert . i have also another table called sundry_items
both tables have a common field called REF
i want my trigger to check after the insert on sundry-items_reply if it has a certain field called recoverd equal to "YES" to go check for the same ref in table sundry-items if this record have a certain field timeout equal to "YES"
if this is the case i want my trigger to make a select on the sundry_items_reply for some reasons why i can't use select on the same table any things cn be done for this issue?

Quote | Subscribe