Re: Help me Oracle Form 5.0

Cesare <me1287_at_mclink.it> wrote in message news:7r1ad5$g6g$1_at_news.mclink.it...
> How I can use "DEFAULT_WHERE" in the SET_BLOCK_PROPERTY when the form is
> runtime ?
>
> thanks

[Quoted] Assign the where clause that you want, the Form will then use it.

e.g.

SET_BLOCK_PROPERTY('MYBLOCK','MYCOLUMN LIKE ''%A%''') (I think I have the variables correct for this, if not, then use Help to look
up the SET_BLOCK_PROPERTY built-in)

You may wish to concatenate any special where clause onto the original where clause, e.g.:

declare
v_original_where_clause varchar2(2000);

begin
v_original_where_clause := GET_BLOCK_PROPERTY('MYBLOCK',DEFAULT_WHERE)

SET_BLOCK_PROPERTY('MYBLOCK',v_original_where_clause ||'MYCOLUMN LIKE ''%A%''')

end;

[Quoted] You would probably run this in a pre-query trigger.

Simon Hedges
Gloucester
UK Received on Mon Sep 06 1999 - 23:42:39 CEST