| Subject | Re: How to send an email notification after a new record inserted. |
|---|---|
| Author | First L |
| Post date | 2010-02-04T17:44:37Z |
Hello,
RAther than use a UDF to send an email, I do something like this:
Have an event log table that a trigger will insert a record into. Then have a periodically running process that will query the table and take the appropriate action (send the email). There may be a UDF that could send an email, but you then also need some error checking and logging in case there is a problem.
In myapp, a user uploads a file to a website, web app logs record, then another process will transfer file to processing queue with some additional information.
Hope that helps.
- Lou
RAther than use a UDF to send an email, I do something like this:
Have an event log table that a trigger will insert a record into. Then have a periodically running process that will query the table and take the appropriate action (send the email). There may be a UDF that could send an email, but you then also need some error checking and logging in case there is a problem.
In myapp, a user uploads a file to a website, web app logs record, then another process will transfer file to processing queue with some additional information.
Hope that helps.
- Lou
--- In firebird-support@yahoogroups.com, "Hoang Quoc G" <hq_giap@...> wrote:
>
> Hi there,
>
> Can someone show me how to get an email notification when a new record is inserted into a table ? For your information, my database is Firebird, and I'm using SQL Manager 2005 Lite to manage my tables / triggers / UDFs / Procedures.
>
> Quoc G.
>