| urgently help required please [message #81131] |
Tue, 14 January 2003 16:41  |
Vinod
Messages: 76
Registered: April 1999
|
Member |
|
|
I am sending an email from forms and the condition is i need to send this email after a record is saved, so which is the trigger that i have to use for calling the mail procedure and also another condition is i should be able to send the mail only if the commit is success, so how to check whether the commit is success.
any help?
Thanks
Vinod
|
|
|
|
| Re: urgently help required please [message #81136 is a reply to message #81131] |
Wed, 15 January 2003 09:29  |
Julie
Messages: 98
Registered: February 2002
|
Member |
|
|
After a successful commit, the form state returns to query. So, I'd code a key-commit trigger with override execution style and code something like this:
Commit_Form;
IF :System.Form_Status = 'QUERY' THEN
your_mail_routine;
ELSE
RAISE Form_Trigger_Failure;
END IF;
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
