Hi Mark

Thanks for the advise but I don't think that is the issue. If you remove the second select statement it compiles and runs fine.

N

--- In firebird-support@yahoogroups.com, Mark Rotteveel <mark@...> wrote:
>
> On Mon, 31 Oct 2011 17:06:34 +0100, Mark Rotteveel <mark@...>
> wrote:
> > I am a bit rusty in my PSQL and trigger code, but as far as I know you
> can
> > do SELECT without INTO like you are doing when calling that SendEmail
> > function (or procedure?).
>
> Uhm, that should have been '.. you can't do SELECT without INTO'. I really
> need to learn to proofread before clicking send.
>
> Mark
>