I could very well be wrong here since I am not an expert, but I don't think
you have a choice.

I have not been able to make a SP that has output variables operate without
"suspend and select" regardless of the number of rows in the output.

Furthermore, in my own experience any selectable SP cannot perform a
transaction since it cannot be commited inside a transaction from the
frontend. VB6+SIBPROVIDER will generate an error when attempted.




-----Original Message-----
From: Jerome Bouvattier [mailto:JBouvattier@...]
Sent: Wednesday, May 12, 2004 9:06 AM
To: firebird-support@yahoogroups.com
Subject: [firebird-support] Selectable or not ?


Hello,

Looking for advice...

For an SP that returns only one value or one "row" (e.g. IsLeapYear,
etc...). Do you prefer to make it selectable (using Suspend) or purely
executable ?

I find a selectable SP more flexible, but maybe I'm missing something.

Thanks.

--
Jerome




Yahoo! Groups Links