Oracle Forms 4.5 List of Value

[Quoted] I have following problem with a Forms-mask:

Using a List of Value (LOV-Button with When-Button-Pressed- Trigger) I have to select some customer data and put them in several mask fields. Standard LOV is too slow for this because of more than 4500 entries.

At the moment I use a separate mask of type LOV. It is called with a call-form at a Key-Listval-Trigger of the used item and fills two global variables (these contains the primary keys of the selected person). After that the 2 variables are used within a When-Validate-Item Trigger to put the right data from database at the mask fields. At the When-Button-Pressed-Trigger of the LOV-Button is also a Go-Item to the item with the LOV.

Although the variables are given back very fast, the complete select is using very much time. Has anybody an idea why, or do you know another possibility to solve this problem?

bye Sigrid Received on Sat Nov 01 1997 - 00:00:00 CET