Home » Developer & Programmer » Forms » :LOV
:LOV [message #77650] Tue, 30 October 2001 00:05 Go to next message
chandrakanth
Messages: 16
Registered: October 2001
Junior Member
Pls. can u give me some details on LOV..how to create LOV popup list and how to populate it in Form6. Pls. give me step by step details. Ex: if i want to bring up poplist using the existing table.column name, how to do that.

Regards.

----------------------------------------------------------------------
Re: :LOV [message #77654 is a reply to message #77650] Tue, 30 October 2001 05:38 Go to previous message
pb
Messages: 18
Registered: December 2000
Junior Member
1. Click on the + sign to create an LOV.
2. Click OK (Use LOV Wizard radio button is selected by default leave it like that)
3. Click Next (New record group based on a query radio button is selected by default leave it like that)
4. Type your sql statement in the SQL query Statement box and click next(example: select empno from emp).
5. Move the columns that you want to be displayed from left side to right side and click next.
6. Click next again.
7. Type the Title if you want to in the Title field and click next.
8. Click Finish.

Go to properties of the LOV you just created.
Click on Column Mapping Properties
Type the name of the column in the form that this value should go to if you pick this value. example emp.empno)

Create a button next to the item in the form and in when button pressed trigger write the following code.

DECLARE
TEMP BOOLEAN;
BEGIN
TEMP := SHOW_LOV('LOVNAME');
END;

Hope this helps!!!

----------------------------------------------------------------------
Previous Topic: sys.V_$PARAMETERS view is misstyped!
Next Topic: FRM-10043, REP-1070,0110
Goto Forum:
  


Current Time: Sun May 31 03:01:50 CDT 2020