Home » Developer & Programmer » Forms » urgently help required please
urgently help required please [message #81131] Tue, 14 January 2003 16:41 Go to next message
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 Go to previous messageGo to next message
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;
Re: urgently help required please [message #81140 is a reply to message #81136] Wed, 15 January 2003 18:13 Go to previous message
Vinod
Messages: 76
Registered: April 1999
Member
thank you very much
Previous Topic: Re: Developer 2000 Tutorial
Next Topic: Calculating Values in a Text -Item
Goto Forum:
  


Current Time: Thu Mar 28 03:42:59 CDT 2024