Hi Alexander

I'm a little confused, the gds32.dll I use is the one with the firebird installation, however are you suggesting it is good practice to put a SUSPEND statement as the last statement in my stored procedures ?.



Rgds

Peter

----- Original Message -----
From: Alexander V.Nevsky
To: firebird-support@yahoogroups.com
Sent: Thursday, October 23, 2003 6:05 PM
Subject: [firebird-support] Re: question about use of SUSPEND statement


--- In firebird-support@yahoogroups.com, <peter@c...> wrote:
> That's put my mind at rest, I never return more than 1 result set
from a stored procedure so I guess I am ok.

You can still have troubles calling from client application more
than one executable procedure with different amount of parameters in
one transaction if occasionally you use Borland gds32.dll on client.
Old workaround for this was to make executable procedure selectable
adding suspend and call them via Select From Procedure.

Best regards,
Alexander.



Yahoo! Groups Sponsor
ADVERTISEMENT




To unsubscribe from this group, send an email to:
firebird-support-unsubscribe@yahoogroups.com



Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.


[Non-text portions of this message have been removed]