Re: Forms 3.0 questions...
Date: 2 May 94 17:39:11 GMT
Message-ID: <1JLPLc1w165w_at_vicuna.ocunix.on.ca>
Hello!
Thanks to everyone who provided pointers on my Forms 3.0 questions. I still have one outstanding problem I'd like to try and solve, thusly:
Steve Frampton <frampton_at_vicuna.ocunix.on.ca> writes:
> I am developing a Forms 3.0 application and have two problems I would
> like to try and solve.
>
> - WARNING: You are about to delete an absence record. I would like to
> provide this message (or something similar) to the user when they
> (usually inadvertently) delete an existing absence record. Ideally the
> form would ask them to confirm or reject the deletion request.
I have tried the following code as a KEY-DELREC trigger (block level):
declare cur_block char(15);
cur_field char(15);
begin
if :ABSENCE_DETAILS.PROCESSED_IND<>'Y' then
:DELETE_CONFIRM.DELETE_IND := 'N';
cur_block := :system.current_block;
cur_field := :system.current_field;
go_block('DELETE_CONFIRM');
go_field('DELETE_IND');
go_block(cur_block);
go_field(cur_field);
if :DELETE_CONFIRM.DELETE_IND = 'Y' then
delete_record; commit;
end if;
else
message('You may not delete processed records.'); raise form_trigger_failure;
end if;
end;
The DELETE_CONFIRM I am referring to is a pop-up block that asks for user-confirmation of the pending delete (via the DELETE_IND variable).
The above code doesn't *do* anything. I think I'm missing something between the two sets of go_block/go_field statements, but for the life of me (newbie) I'm not sure what...all I want to do is have the user enter a 'Y' or 'N' into DELETE_IND and then press <Enter>.
Any information would be most appreciated. Thanks in advance!
---< MAKE MONEY FAST! Contact Dave Rhodes for details. >--- Steve Frampton E-mail: <frampton_at_vicuna.ocunix.on.ca> Received on Mon May 02 1994 - 19:39:11 CEST