Home » Developer & Programmer » Forms » execute query-lov problem
execute query-lov problem [message #235823] Tue, 08 May 2007 01:52 Go to next message
karthick2809
Messages: 50
Registered: April 2007
Location: Chennai
Member
hi experts,
i have designed a form using forms 9i for the table

create table emp( emp_id number,emp_name varchar2(20),dept_id number);
there is a master table for depatment
create table dept(dept_id number,dept_name varchar2(20);

In the datablock emp i have got 3 fields.
emp_id -----database item
emp_name -----database item
dept_name -----non data base item
i have got an lov emp_lov for the dept_name.when user chooses the lov item,the dept_id in lovgets mapped to the dept_id of emp table and dept_name gets displayed...
i have used post-query trigger to fetch the dept_name according to the emp_id..
but when evr i give execute query ,the lov which is set on the non database item dept_name gets fired...how can i stop that..please help me out with your valuable tips..
thanks in advance
Re: execute query-lov problem [message #235843 is a reply to message #235823] Tue, 08 May 2007 02:43 Go to previous messageGo to next message
kamran.it
Messages: 265
Registered: September 2005
Location: Karachi
Senior Member
I think you have defined Return Item value in Column mapping.
check this go to LOV property -> column mapping property --return Item.
Re: execute query-lov problem [message #235850 is a reply to message #235823] Tue, 08 May 2007 02:54 Go to previous messageGo to next message
karthick2809
Messages: 50
Registered: April 2007
Location: Chennai
Member
thanks kamran
s i have defined it..how to solve it...i hvn't displayed the dept_id in the layout of the datablock..
Re: execute query-lov problem [message #235860 is a reply to message #235823] Tue, 08 May 2007 03:25 Go to previous messageGo to next message
karthick2809
Messages: 50
Registered: April 2007
Location: Chennai
Member
can u tel me which trigger gets fired when an lov item is selected..so that i can unmap the column and write code in it
Re: execute query-lov problem [message #236761 is a reply to message #235860] Thu, 10 May 2007 21:33 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Key-Listval is the trigger but you should fix the LOV characteristics first.

David
Re: execute query-lov problem [message #237185 is a reply to message #235823] Sun, 13 May 2007 01:37 Go to previous messageGo to next message
karthick2809
Messages: 50
Registered: April 2007
Location: Chennai
Member
i hvn't solved my problem yet. the lov is getting fired as soon as give execute query..how to resolve this
Re: execute query-lov problem [message #237203 is a reply to message #235823] Sun, 13 May 2007 04:59 Go to previous messageGo to next message
Hisham79
Messages: 14
Registered: December 2006
Location: Riyadh - Saudi Arabia
Junior Member

What did you write in your post-query trigger ?
Re: execute query-lov problem [message #237224 is a reply to message #237185] Sun, 13 May 2007 10:52 Go to previous message
Littlefoot
Messages: 20900
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Search through PL/SQL code units (all at once if you know how, or - if manually , triggers first, then - if necessary - the others) for
LIST_VALUES;
statement. If / when you find it, comment it (put double 'minus' -- sign in front of it), recompile and run the form.
Previous Topic: Webutil
Next Topic: General
Goto Forum:
  


Current Time: Thu Dec 08 04:04:21 CST 2016

Total time taken to generate the page: 0.11941 seconds