Re: Forms 4.5 performance problem

Steve Johnson <robertoc_at_fyiowa.infi.net> wrote in article <34195956.2319_at_fyiowa.infi.net>...
> I've done something similar to this by having my base table blocks
> be views and dynamically creating them at run time. You have to be
> careful though because the base table items must always remain the
> same type and size.
>
> Good luck
>
> Steve J.
>
> Don Huesman wrote:
> >
> > I have a form with two blocks referencing two tables. The default
> > select statement gives me a performance problem, apparently as a result
> > of not using existing indexes. Is there a way of controlling the
> > default select statement other than controlling the where clause? I
> > want to control the 'from clause' used by select to pull a key from one
> > table to use against the next. Or stated more simply, I want to write
> > my own select statement. Can this be done?
>

Have you tried with ON-SELECT and ON-FETCH triggers ?

Mario Simic
IN2 d.o.o.
Zagreb, Croatia Received on Sun Sep 14 1997 - 00:00:00 CEST