| appropriate trigger [message #261334] |
Wed, 22 August 2007 06:07  |
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  |
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 |
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
