| key-Enter [message #155690] |
Wed, 18 January 2006 00:45  |
plsql11
Messages: 7
Registered: December 2005
|
Junior Member |
|
|
Hi,
Can anyone clarify the use of this trigger please.
Regards.
|
|
|
|
| Re: key-Enter [message #155822 is a reply to message #155690] |
Wed, 18 January 2006 16:27  |
 |
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
|
Senior Member
Account Moderator |
|
|
Its the command to simulate an 'Enter' key press.
The following is from the Reference Manual
EXECUTE_TRIGGER built-in
Description - EXECUTE_TRIGGER executes an indicated trigger.
Syntax
PROCEDURE EXECUTE_TRIGGER
(trigger_name VARCHAR2);
Built-in Type - restricted procedure (if the user-defined trigger calls any restricted built-in subprograms)
Enter Query Mode - yes
Note: EXECUTE_TRIGGER is not the preferred method for executing a user-named trigger: writing a user-named subprogram is the preferred method.
Parameters - trigger_name Specifies the name of a valid user-named trigger.
Usage Notes
Because you cannot specify scope for this built-in, Form Builder always looks for the trigger starting at the lowest level, then working up.
To execute a built-in associated with a key, use the DO_KEY built-in instead of EXECUTE_TRIGGER.
For example, rather than:
Execute_Trigger ('KEY-NEXT-ITEM');
Use instead:
Do_Key('NEXT_ITEM');
EXECUTE_TRIGGER restrictions
Although you can use EXECUTE_TRIGGER to execute a built-in trigger as well as a user-named trigger, this usage is not recommended, because the default fail behavior follows a different rule than when invoked automatically by Form Builder as part of default processing. For example, in default processing, if the When-Validate-Item trigger fails, it raises an exception and stops the processing of the form.
However, if the When-Validate-Item trigger fails when it is invoked by EXECUTE_TRIGGER, that failure does not stop the processing of the form, but only sets Form_Failure to FALSE on return from the EXECUTE_TRIGGER built-in.
David
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
