Re: Trapping Delete in Forms 4.5

Hello,
i have used a KEY-DELREC trigger
v_ret := AlertMessage(...);
IF v_ret = alert_button1 then
  delete_record;
else
  null; -- or do something
end if;

Cleve Sharpe <cleve_at_cbcsf.org> schrieb im Beitrag <01bc55e3$7f38d760$686482d0_at_cbcsf1.techlink.net>...
> I have a simple problem but haven't been able to solve it for 2 hours.
 How
> do I do the following with a WHEN-REMOVE-RECORD trigger or a KEY-DELREC
 or
> ON-DELETE trigger, etc. (I am pretty sure that it should be the
> WHEN-REMOVE-RECORD trigger):
>
> When the user presses Shft-F6 to delete a record
> 1. I pup up a Yes/No alert box.
> 2. If the user selects YES then
> I want to delete the record
> Else
> I leave the record intact.
> End if
> The first part (1) works as expected but I can't get part 2 to work
> properly. It seems that the record gets deleted anyway (whether YES is
> selected or NO)... By the way, I do return the value of the alert box
> selection into a variable and use it in my IF statement so that is
 probably
> not the problem.
>
> Cleve.
>
>
>
>
Received on Mon May 05 1997 - 00:00:00 CEST