dmiller@... [firebird-support] a écrit :

> That's just an "anonymous" procedure. I suppose it is technically something a
> client can run without having to define it in the database first - but I was
> hoping for something using just insert & select.

I do not understand English enough to feel the finesse of your
question.
but, if execute block does not suit you, there is always the
possibility with merge when matched .. / when not matched then insert
..

--
Norbert Saint Georges
http://tetrasys.fi