Re: Help me Oracle Form 5.0

Simon Hedges wrote:
>
> 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)

The right syntax is

  SET_BLOCK_PROPERTY('MYBLOCK',DEFAULT_WHERE,'MYCOLUMN LIKE ''%A%''') <skip>

> You would probably run this in a pre-query trigger.
>
> Simon Hedges
> Gloucester
> UK

-- 
Valeri Sorokine
ProSoft, Russia, Moscow, Information Systems Division
Phone: +7 (095) 234 0636 (6 lines) FAX: +7 (095) 234 0640
E-mail: vsorokin_at_dd.ru OR vsorokin_at_prosoft.ru
http://www.dd.ru