yes indeed -- commit is unknown inside stprocs. I should have run
the code first. :-)

Thanks Martijn.

--- In ib-support@y..., "Martijn Tonies" <martijn@b...> wrote:
> Hi,
>
> I would be surprised if you could get this compiled ...
Commit/rollback
> isn't supported inside stored procedures - these always run in the
> client transaction context.
>
> So, no harm to be done :)
>
> Martijn Tonies
> InterBase Workbench - the developer tool for InterBase and Firebird
> http://www.interbaseworkbench.com
>
>
>
> I noticed that commits aren't used inside stprocs -- well, not in
the
> doc examples. Is there any harm in including hard commits inside
> stprocs or will this cause problems, e.g.
>
> create procedure (etc.)
> begin
> insert into ...;
> commit;
> update foobar set ...;
> commit;
> end