Subject Re: [firebird-support] How to send an email notification after a new record inserted.
Author Ann W. Harrison
Hoang Quoc G 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.
>

What I would do is have a trigger on the table that
posts an event when the action you want happens, then
have a separate application that waits on the event,
sending e-mail when it happens. Avoids polling.


Cheers,

Ann