OraFAQ Forum: Forms » Which trigger do I use?

Home » Developer & Programmer » Forms » Which trigger do I use?

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

Which trigger do I use? [message #154028]

Thu, 05 January 2006 07:12

orahugo
Messages: 32
Registered: October 2005
Location: England

Member

This is an example of my problem.

I've got two blocks. Block A and block B.

Block A has two items; ID and Size.

Block B has one items; Colour.

I run a query and select from a LOV the values that put the data into the two fields in Block A.

I want a trigger to run, as soon as the item 'ID' is changed in Block A it runs a piece of SQL that inserts a value into the item called 'Colour' in Block B.

What trigger do I use to do this? And on what item?

Report message to a moderator

Re: Which trigger do I use? [message #154042 is a reply to message #154028]

Thu, 05 January 2006 08:11

vakkalan
Messages: 20
Registered: January 2006
Location: US

Junior Member

orahugo,
I would write the query on when button pressed of LOV.

1. When the button is pressed show the LOV.. sample code is below

DECLARE a_value_chosen BOOLEAN; 
BEGIN 
a_value_chosen := Show_Lov('id_lov'); 
IF a_value_chosen THEN 
 :block_b.color :=  <your value>
END IF;

Hope this Helps

HARSHA VAKKALANKA

Report message to a moderator

Previous Topic:	oracle report problem
Next Topic:	Customizing Error message in the password expire dialog

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 02:30:24 CDT 2024