| LOV Problem - very very urgent [message #83773] |
Wed, 10 December 2003 05:25  |
Deepak
Messages: 111
Registered: December 1999
|
Senior Member |
|
|
Hi Gurus,
in my form , 1st item has attached lov,when the val is selected from lov it return the val in the same item.
i want to execute_query for the val returned & populate data of other fields(which are display item)
i've tried to write foll. triggs but no use
1. key-next-item
execute_query
2. key_list_val
execute_query
pl. suggest more than 1 or max alternate solns.
so that i'll try all & atleast 1 should work
Thanks & regards
|
|
|
|
| Re: LOV Problem - very very urgent [message #83775 is a reply to message #83773] |
Wed, 10 December 2003 20:02  |
Prag
Messages: 7
Registered: December 2003
|
Junior Member |
|
|
Hi Deepak,
All your fields r from the same table?
Can't u use the when-validate trigger with the item 'val' to populate the other fields? try the following assuming f1, f2, f3 are the fields of table1 and :f1, :f2, :f3 r the corresponding fields in the form.
select f1, f2, f3 into :f1, :f2, :f3 from table1
where val=:val;
It is the easiest way. Try it if the job is very very urgent for the time being.
But if u r determined to use execute_query feature then well I'm also trying your code on my machine and let u know.
Regards,
Prag
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
