Subject Re: [firebird-support] Re: Deadlock
Author Lucas Franzen

sgharp schrieb:

> 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.