Re: Oracle Forms 4.5 List of Value

Probably an "order by" that doesn't correspond to the index used by the where-clause, or, in absence of where-clause, to no index at all.

-- 
Kind reGards,

Gerard
(ghp_at_santens.be; ghp_at_skynet.be)

Sigrid Staudte <mstaudte_at_rz.uni-leipzig.de> schreef in artikel
<345B60D2.3CEF2B73_at_rz.uni-leipzig.de>...


> 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

>