Subject Re: Deadlock
Author sgharp
--- In, Lucas Franzen <luc@r...>
> > I put a suspend at the end of all my stored procedures. I
> > it was required to wrap things up (commit records,etc.).
> No, a sp never can commit anything - it will always be committed
> 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
> 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...