OraFAQ Forum: Forms » execute query-lov problem

Home » Developer & Programmer » Forms » execute query-lov problem

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

execute query-lov problem [message #235823]

Tue, 08 May 2007 01:52

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

Report message to a moderator

Re: execute query-lov problem [message #235843 is a reply to message #235823]

Tue, 08 May 2007 02:43

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.

Report message to a moderator

Re: execute query-lov problem [message #235850 is a reply to message #235823]

Tue, 08 May 2007 02:54

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..

Report message to a moderator

Re: execute query-lov problem [message #235860 is a reply to message #235823]

Tue, 08 May 2007 03:25

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

Report message to a moderator

Re: execute query-lov problem [message #236761 is a reply to message #235860]

Thu, 10 May 2007 21:33

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

Key-Listval is the trigger but you should fix the LOV characteristics first.

David

Report message to a moderator

Re: execute query-lov problem [message #237185 is a reply to message #235823]

Sun, 13 May 2007 01:37

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

Report message to a moderator

Re: execute query-lov problem [message #237203 is a reply to message #235823]

Sun, 13 May 2007 04:59

Hisham79
Messages: 14
Registered: December 2006
Location: Riyadh - Saudi Arabia

Junior Member

What did you write in your post-query trigger ?

Report message to a moderator

Re: execute query-lov problem [message #237224 is a reply to message #237185]

Sun, 13 May 2007 10:52

Littlefoot
Messages: 21823
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.

Report message to a moderator

Previous Topic:	Webutil
Next Topic:	General

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Feb 02 16:04:32 CST 2025