OraFAQ Forum: Forms » which trigger fires when we give execute query from menu?

Home » Developer & Programmer » Forms » which trigger fires when we give execute query from menu?

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

which trigger fires when we give execute query from menu? [message #235378]

Sat, 05 May 2007 07:44

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

Report message to a moderator

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

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

Report message to a moderator

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

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

Report message to a moderator

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

karthick2809
Messages: 50
Registered: April 2007
Location: Chennai

Member

thanks...it works fine....

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Feb 02 13:01:20 CST 2025