Home » Developer & Programmer » Forms » URGENT: Auto mail a user on changing a field value
URGENT: Auto mail a user on changing a field value [message #229082] Thu, 05 April 2007 05:24 Go to next message
svik
Messages: 16
Registered: April 2005
Location: MRU
Junior Member
Hi to all,

In sqlforms 3.0.16.12.09 and database version 7.1.6.2.0, is it possible to add a trigger on a field, e.g date_left, so that whenever the user input a date in the field, a mail is automatically sent to another user. The mailing system is
SuSE Linux Openexchange Server CA.

Thanks for giving me an answer till tomorrow morning 06/04/2007.

Re: URGENT: Auto mail a user on changing a field value [message #230090 is a reply to message #229082] Tue, 10 April 2007 19:42 Go to previous message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Yes. Use DBMS_PIPE.

Search this SITE or google it.

David
Previous Topic: Master Details - Final commit
Next Topic: insert record and display on form automatically
Goto Forum:
  


Current Time: Fri Dec 09 11:37:43 CST 2016

Total time taken to generate the page: 0.06892 seconds