Re: Control over LOV popup size in forms 5.0

Frans is right - an LOV will always try to load all rows - a form will at maximum retrieve the buffered records (by default, buffered equals displayed). Requires some fiddling with globals, tho to pass values

Frans Hovenkamp wrote:

> Glenn,
> I think it would be better to use a LOV-Form with a query-block instead of a
> normal LOV
>
> Frans Hovenkamp
>
> G&K F <zotje_at_my-deja.com> wrote in message
> news:8u9r6b$4cn$1_at_nnrp1.deja.com...
> > I am trying to pop up an lov for a text item and let it query on any
> > text populated in the text box. This works fine, but very slowly since
> > there are over 100,000 distinct rows in this table. So, I turned on
> > the lov property filter on display. When I do this, the lov pops right
> > up, but it only shows me 1 row of data, unless I have a title for the
> > columns, in which cases it only displays the titles. Is there a way to
> > adjust the height of the lov with the filter on display property turned
> > on ? I'd like at least 3 rows to return.
> >
> > Thanks,
> > Glenn
> >
> >
> > Sent via Deja.com http://www.deja.com/
> > Before you buy.

--
Gtrz,

Frank van Bortel