Thank you all for your help and advice.

N

--- In firebird-support@yahoogroups.com, Mark Rotteveel <mark@...> wrote:
>
> On Tue, 01 Nov 2011 10:00:38 +1300, Helen Borrie <helebor@...>
> wrote:
> > At 07:56 AM 1/11/2011, you wrote:
> >>On 31-10-2011 17:46, grip_2ls wrote:
> >>> 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.
> >>
> >>That was exactly the issue I was pointing out. You are using SELECT
> >>without INTO to call SendMail. That doesn't work as Sean also pointed
> out.
> >
> > Furthermore, invoking that Sendmail procedure as a select procedure is
> not
> > sensible in this environment or any other. Make it an executable
> procedure
> > and, in the trigger code, call it with EXECUTE PROCEDURE (:var1, :var2,
> > etc.) Selectable procedures are intended to return sets and shouldn't
> be
> > used to execute DML.
>
> Helen, it was actually a singleton select against RDB$DATABASE calling the
> SendMail UDF in the column list.
>