--- In firebird-support@yahoogroups.com, Lucas Franzen <luc@r...>
wrote:

> > I put a suspend at the end of all my stored procedures. I

thought

> > it was required to wrap things up (commit records,etc.).
>
> No, a sp never can commit anything - it will always be committed

from

> the outside (the client is responsible for doing so)!
>
> Suspend is used when you're returning datasets (records ).
> Suspend in a FOR SEELCT .. DO BEGIN .. loop will write the data to

the

> output so you can have selectable procedures.
>
> Procedure that are EXECUTED shouldn't contain suspend.
>
> Procedure that are selected from should.
>
> Procedures that do DML shouldn't be selectable.
>
> Remove the SUSPEND and try again.

Removing the suspend did it! Thanks much...

Steve