willogibbo wrote:

> Thanks, Lester, very helpful.
>
> One thing I can't figure is how you handle creating a trigger or
> stored procedure with an sql statement i.e. where you have semi colons
> in the body of what you're creating. Also how do you cope with the
> 'SET TERM' top and tail?

You are only processing one statement at a time so you don't need the
SET TERM. That is only needed so you can put a terminator after each
statement in a script. If you execute a CREATE TRIGGER then the extra
semi-colons are not a problem ;)

--
Lester Caine
-----------------------------
L.S.Caine Electronic Services
Treasurer - Firebird Foundation Inc.