look_up Pop_Up in SQL*Forms 2.3

From: David N McCann <cs91dnm_at_brunel.ac.uk>
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

Original text of this message