Hi Ed !

> From: Epstein, Ed
> To: 'firebird-support@yahoogroups.com'
> Sent: Wednesday, May 12, 2004 6:25 PM
> Subject: RE: [firebird-support] Selectable or not ?
>
>
> 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.

Try execute procedure YOUR_SP(<your_params>) returning_values :outputvar1
:outputvar2 ...;

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

Sorry, I don't see in what it's relevant here.

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