Home -> Usenet -> comp.databases.oracle -> Forms4.0 LOV Question

Forms4.0 LOV Question

From: Wallace Fukumae <fukumae_at_io.nosc.mil>
Date: 2 Dec 1993 04:21:27 GMT
Message-ID: <2djqg7$5sj_at_pandora.sdsu.edu> 






I am running SQLForms 4.0.9 Beta, Oracle 7.0.13, SunOS 4.1.3.



Created a LOV with the 'where' clause containg a global variable.
I was hoping to create a LOV which at run-time will display
a list based on the criteria specified in the global variable.



The LOV works only one time.  Then I run into the oracle error
stating that 'can't read List of Values'.



I tried creating the LOV with a block.item field.  It works
however when you move the cursor to another record and then
call the same routine the LOV displays the values based on the
first record criteria selected.I displayed messages and
the values seem to be there.  



Need to create a LOV filtered based on the criteria selected
for the form.  Either using a global variable or block.item.



Is this possible?



Thanks in advance, Wally
Received on Thu Dec 02 1993 - 05:21:27 CET












Original text of this message