Home » Developer & Programmer » Forms » Query LOV and how to display the LOV back in the Text item. (Oracle Forms)
Query LOV and how to display the LOV back in the Text item. [message #329346] Wed, 25 June 2008 03:03 Go to next message
Messages: 7
Registered: June 2008
Junior Member

I have got a big time problem in getting back my LOV value after Querying it.

Am using a Tabular Canvas having 10 rows and two columns, one having "Type"(as LOV) and corresponding "Type identifier".

My LOV is an non data block item, having the correct return type. When ever i search for a value in the LOV, its should give out all the "Type Identifier" list and the "Type".

But what i am facing is, am not able to get back the selected LOV after querying it and am getting the entire "Type Identifier' with out any filter.

In short my requirement is,
- I need to search an LOV,
- Display the LOV value in the "TYPE" field.
- Display the corresponding "Type Identifiers'

Pls note: Since am new to Oracle Forms, if in your replies, if you specify to use any code in trigger, pls specify which trigger to use.

Thanks a lot in Advance... its bit urgent

Re: Query LOV and how to display the LOV back in the Text item. [message #329472 is a reply to message #329346] Wed, 25 June 2008 09:10 Go to previous message
Messages: 22
Registered: June 2008
Junior Member
1. Right-click the lovs in object navigator, show a sub-menu
2. Chose the lov wizard, show a new lov wizard screen
3. Select "new record group based on query", and click next button, show a new screen
4. Typing your sql in sql query statement, and click next button
5. Chose all columns which you require ex. "Type Identifier" ,"Type"(chose the colomn name in left list and click the button '>', it will be add to right list), then click next button, show a new screen.
6. This step is most important, as it will defind return value and columns relation, you will see a grid in the top of this screen, you will see a colomn in the grid named "return value", this "return value" is used to defind the value will be return to which fields, click the "return value", then clikc then "look up return item.." button, will be show a list, you can chose the fields which you want to return value from LOV, then click next button, show a new screen.
7. Type title, width and height which you need, then click next button
8. click next button
9. Move items which you want to show lov in it from left list to right list.
10. click next finish button
11. create a button on the form
12. type blow code in the button trigger when-button-press, replace 'Your LOV name' to your lov name
a_value_chosen BOOLEAN;
a_value_chosen := show_lov('Your LOV name');
IF NOT a_value_chosen THEN
message('You have not selected a value.');
RAISE form_trigger_failure;
Previous Topic: Master/detail tables, problem interconnecting with an id
Next Topic: get column sum if its records are checked
Goto Forum:

Current Time: Wed Aug 23 10:55:37 CDT 2017

Total time taken to generate the page: 0.01694 seconds