SQL%notfound
From: Mike Oswald <moswald_at_cwis.unomaha.edu>
Date: Mon, 14 Jun 1993 20:38:28 GMT
Message-ID: <1993Jun14.203828.20224_at_news.unomaha.edu>
Date: Mon, 14 Jun 1993 20:38:28 GMT
Message-ID: <1993Jun14.203828.20224_at_news.unomaha.edu>
I thought by writing the following it would prevent the user from deleting
records if the record exists in a related table but it doesn't work. The
coded segment can be found in SQL*Forms v3, KEY-DELREC trigger.
declare
cursor CNV_CUR is
SELECT *
FROM <table_1> a
WHERE a.field = :<block>.<field> ;
begin
if SQL%notfound then
delete_record ;
else
<blah>
end if ;
end ;
Received on Mon Jun 14 1993 - 22:38:28 CEST