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

--- In firebird-support@yahoogroups.com, Alexandre Benson Smith
<iblist@t...> wrote:

> Myles Wakeham wrote:
>
> >I'd like to find a way to have Firebird send an email when a

specific table

> >encounters an INSERT on it. Can this be done from within

Firebird?

> >
> >Myles
> >
> >===========================
> >Myles Wakeham
> >Director of Engineering
> >Tech Solutions Inc.
> >Scottsdale, Arizona USA
> >Phone (480) 451-7440
> >Web: www.techsol.org
> >
> >
> >
> >
> Yes,
>
> With an UDF
>
> see you !
>
> --
>
> Alexandre Benson Smith
> Development
> THOR Software e Comercial Ltda.
> Santo Andre - Sao Paulo - Brazil
> www.thorsoftware.com.br