Re: Forms 4.5 help req.

From: Richard Brands <wncreb_at_cco.wnc.nedlloyd.nl>
Date: Mon, 18 May 1998 10:59:14 +0100
Message-ID: <35600672.2A93_at_cco.wnc.nedlloyd.nl>


®èðÇöûþé wrote:
>
> 1) After deleting/adding/ammending a record, is there a way to
> requery/refresh the current content on the screen?
>
> 2) Is there a way to do something like this:
>
> enter_query;
> :tbxPersonCode := 9090
> execute_query;
>
> --
>
®èðÇöûþé,

Try it with the following procedure:
procedure name is
  old_qry varchar2(200);
begin

   old_qry := get_block_property('block',DEFAULT_WHERE);    set_block_property('block',DEFAULT_WHERE, 'tbxPersonCode = 9090');    execute_query;
   set_block_property('block',DEFAULT_WHERE,old_qry); end ;

Hope this helps.

Richard Received on Mon May 18 1998 - 11:59:14 CEST

Original text of this message