Re: Forms 3.0 questions...

From: Steve Frampton <frampton_at_vicuna.ocunix.on.ca>
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