look_up Pop_Up in SQL*Forms 2.3
Date: Mon, 21 Jun 1993 14:21:49 GMT
Message-ID: <C8z6KD.KpC_at_brunel.ac.uk>
Hi,
I'm fairly new to Oracle, but I'm learning fast. I wondered if there was a way to do a pop-up lookup table. I'm not too worried about the pop-up bit, its the lookup table part i'm interested in.
Desired Operation:
From a Field (say Num) the user hits a key (say [List Field Values]) a key-trigger catches this and brings up a scrollable list of valid values for Num from table Num_values. The user can scroll and query the list BUT ABSOLUTELY NOT change the data. When they've found the value they want thet hit (say) [Accept] and the current value gets placed in the calling form and they're returned to it.
Other possible features:
The first value displayed in the list is the current (possibly invalid) value from the Num field on the calling form.
The box is a true pop-up, overlaying part of the calling form. This function is definately NOT required, but it would be nice.
Unfortunately I am constrained to V2.3, so answers using V3.0 are no good, sorry. If it makes any difference, the full version numbers are:-
ORACLE RDBMS 6.0.33.1.1 SQL*Plus 3.0.6.6.1 PL/SQL 1.0.31.0.2 SQL*Forms 2.3.31.1.3
Many thanks in advance for any info you can provide,
David McCann
P.S. I've tried creating a field with just the *Displayed attribute set, but SQL*Forms then refuses to run it at all (its the only field on the form) Received on Mon Jun 21 1993 - 16:21:49 CEST