Re: Result set forms 4.5 (LOV)

I can suggest two things for this.

1. I would question an open query on that many records. Will users really scroll through that many items? Change the functionality of you LOV to not perform an open query (one where you return all rows). Make sure that the LOV includes a line of the form

AND MYCOL LIKE :myfield || '%'

so that you have to have types in a part value before you can initiate the LOV function. Change the LOV key trigger to only fire off LOV if the field is not empty. OF course, the query might still be slow.

2) Alternatively, write your own LOV form. Create a seperate form which you call (in query only mode) to display the set you want, passing the row back by using GLOBALS (or similar). If you actually code it as a form you have tighter control over retrieving the records (array size and the like).

HTH
--
Alan D. Mills

xx wrote in message <35DC24BA.8A680971_at_eexi.gr>...
>I use ORACLE 7.3, forms 4.5 and I work on a table of 160000 raws.
>I have create a LOV which retrieves all the raws from the table, but I
>have to wait at least 15 min because ORACLE client WAITS TO GET all the
>raws from the server before LOV displayed.
>Is there any way to display any data retrieved before the query finished
>
>?
>
>10q in advance!
>
Received on Thu Aug 20 1998 - 09:42:46 CDT