Zlatko Sirotic wrote:
Surely you know that you can increase the fetch size for records group (default is 20) and that you can use the Filter Before Display property on the LOV.
But, I think the only real way with such a large number of data is - use independent Forms module LOV, instead of the built-in LOV.
fetch size for records group (default is 20) ---> Already changed it and check.. No use for that...
Filter Before Display property on the LOV ---> I don't want this functionality.
Independent Forms module LOV ---> Means? Can you explain a bit more?
Message was edited by: AnnPricks E
Something like this (from the EMP - DEPT story):
In EMP Forms module:
-- KEY-LISTVAL trigger on :emp.deptno
call_form('dept_lov', NO_HIDE, NO_REPLACE, QUERY_ONLY, NO_SHARE_LIBRARY_DATA);
IF NOT form_success THEN
IF :GLOBAL.deptno_lov IS NOT NULL THEN
:emp.deptno := :GLOBAL.deptno_lov;
WHERE deptno = :emp.deptno;
WHEN OTHERS THEN
In DEPT_LOV Forms module:
-- KEY-COMMIT trigger
/* Sets the global variables passed back to calling form */
:GLOBAL.deptno_lov := :dept.deptno;