Re: developer 2000 sift+f6 delete record

Hi Sharma,

What about KEY-DELREC trigger?

Hope that helps.

ssharma24_at_my-deja.com wrote:
>
> I have a block on which I want to put a trigger to catch delete
> operation. it will check if the record you are deleted has any related
> child records. I put a delete button and I put that condition in
> there. But you can still delete a record by using shift+f6 or delete
> key. What trigger should I put my code in and what level that trigger
> should be at. I thought a predelete trigger at block level will do the
> job. but it didn't work.
> My code basically will get a count from related table if the count is
> <> 0, it will put a message that you can't delete.....
>
> thanks
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.

-- 
Valeri Sorokine
Oracle Certified Application Developer, Rel.2
ProSoft, Russia, Moscow, Information Systems Division
Phone: +7 (095) 234 0636 ; FAX: +7 (095) 234 0640
E-mail: vsorokin_at_dd.ru   ; http://www.dd.ru