What we do is insert into an 'Email Queue' table.

The insert into this table has an event that fires off on insert. We have an
app (or service) listening for the event, it also periodically checks the
email queue as well in case it missed an event (eg was not started at the
time of event).

Haven't thought about how rolled back transactions affect this... But it is
not important to us for how we use it.

Regards
Colin

-----Original Message-----
From: Alan McDonald [mailto:alan@...]
Sent: Thursday, 17 June 2004 1:26 p.m.
To: firebird-support@yahoogroups.com
Subject: RE: [firebird-support] Re: Emailing from Firebird 1.5 (Linux) in a
trigger?

> > On 16-Jun-2004 15:30:09, Alexandre Benson Smith wrote:
> > johnsparrowuk wrote:
> >
> > >It might be better (though more complex) to do it in response to an
> > >event - that way it will only happen on commit.
> > >
> > >A trigger will fire when INSERT takes place (sending the email).
> > >But that could then be rolled back...
> > >
> > >John
> > >
> > >
> > >
> > Agreed !
>
> OK, but how do I do it?
>
> Regards,
> Myles

You cannot do it from the server, nor is it recommended to create and use a
UDF for this. Your best option at this time is to have a separate
application running and listening for the event and firing an email
separately.
Alan




------------------------ Yahoo! Groups Sponsor --------------------~--> Make
a clean sweep of pop-up ads. Yahoo! Companion Toolbar.
Now with Pop-Up Blocker. Get it for free!
http://us.click.yahoo.com/L5YrjA/eSIIAA/yQLSAA/67folB/TM
--------------------------------------------------------------------~->


Yahoo! Groups Links






######################################################################
Attention:
The information in this email and in any attachments is confidential.
If you are not the intended recipient then please do not distribute,
copy or use this information. Please notify us immediately by return
email and then delete the message from your computer.
Any views or opinions presented are solely those of the author.
######################################################################