| :LOV [message #77650] |
Tue, 30 October 2001 00:05  |
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  |
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!!!
----------------------------------------------------------------------
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
