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>
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