Home » Developer & Programmer » Forms » LOV Problem - very very urgent
LOV Problem - very very urgent [message #83773] Wed, 10 December 2003 05:25 Go to next message
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 Go to previous message
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
Previous Topic: Keyboard Mapping FRMWEB.CFG
Next Topic: loading image BLOB?
Goto Forum:
  


Current Time: Mon Aug 15 05:02:50 CDT 2022