Home » Developer & Programmer » Forms » appropriate trigger
appropriate trigger [message #261334] Wed, 22 August 2007 06:07 Go to next message
sispk6
Messages: 164
Registered: November 2006
Location: pakistan
Senior Member
i have l.o.v on deptno ,
when i select deptno , i have written code so that dname
and loc are populated automatically,
i have written code on
post-text item.
tell me which is the most appropriate trigger
for this situation
Re: appropriate trigger [message #261358 is a reply to message #261334] Wed, 22 August 2007 06:44 Go to previous message
bbaz
Messages: 138
Registered: April 2007
Senior Member
Hello,

Why do you need ANOTHER trigger to populate the DNAME and LOC field after selecting the DEPTNO? You said you want the population automatic once you have chosen your DEPTNO from the LOV, so you can have the other fields populated inside the SAME trigger (ex: WHEN-BUTTON-PRESSED) that called the LOV.

I have used the following code:

declare
lov_return boolean; 
begin 


lov_return := show_lov('your LOV NAME deptno'); 
 
IF lov_return THEN 
:blockName.DEPTNO := :parameter.LOV_DEPTNO; -- (U can create a parameter to store the LOV return)

***** HERE YOU CAN HAVE THE REST OF YOUR CODE FOR POPULATING THE OTHER ITEMS *****


END IF;


Hope this helps,
Baz

[Updated on: Wed, 22 August 2007 06:47]

Report message to a moderator

Previous Topic: How to create a "Search Form"
Next Topic: how to get data from a text item
Goto Forum:
  


Current Time: Wed Dec 07 18:36:57 CST 2016

Total time taken to generate the page: 0.14250 seconds