Home » Developer & Programmer » Forms » which trigger fires when we give execute query from menu?
which trigger fires when we give execute query from menu? [message #235378] Sat, 05 May 2007 07:44 Go to next message
karthick2809
Messages: 50
Registered: April 2007
Location: Chennai
Member
hi experts
i have designed a form using oracle 9i...
there are two fields,
emp_id text_item ---database item
branch_name display_item ---non database item

i have created an lov for branch_name named br_lov.
i have mapped branch_id(br_lov) to emp.emp_id and
branch_name(br_lov) to emp.branch_name

when is save it in database ,the branch_id gets stored..it works fine..no proble with it..


but when i give execute query only employee id is getting displayed...the nondatabase item branch_name is left empry..i want to display the branch_name in it..may i please know which trigger gets fired when we give execute_query...so that i wil write the corresponding code in it..


table structure:
---------------
create table emp(emp_id number primary key,branch_id number,);

create table branch(branch_id number primary key,branch_name varchar2(20));



thanks in advance
Re: which trigger fires when we give execute query from menu? [message #235379 is a reply to message #235378] Sat, 05 May 2007 07:48 Go to previous messageGo to next message
karthick2809
Messages: 50
Registered: April 2007
Location: Chennai
Member
also the alignment of the label which i have given for the nondatabase is not proper..its is not getting displayed where i actually wanted to display..
Re: which trigger fires when we give execute query from menu? [message #235429 is a reply to message #235379] Sat, 05 May 2007 12:37 Go to previous messageGo to next message
Littlefoot
Messages: 20896
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Populate the non-database item in a POST-QUERY trigger. I believe that you should be able to put it together (if you know how to create a form); it is really a trivial one - SELECT something INTO :block.item WHERE id = :block.id.

Set the label using item's Property Palette.
Re: which trigger fires when we give execute query from menu? [message #235458 is a reply to message #235378] Sun, 06 May 2007 06:14 Go to previous message
karthick2809
Messages: 50
Registered: April 2007
Location: Chennai
Member
thanks...it works fine....

Previous Topic: problem with forms 10g at runtime
Next Topic: connection problem
Goto Forum:
  


Current Time: Tue Dec 06 02:23:15 CST 2016

Total time taken to generate the page: 0.11462 seconds