It was only relevant to output variables in general. I had tried to make SP
procedures before that would perform inserts and updates based on input
variables and then return status codes to me in the output variables. I
could gain access to those output variables using select without a problem,
however when it came to commit the transaction I would generate an error in
my front-end. However I never did try your code though. I will try to
adapt that to VB6+ADO.

>> 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:57 AM
To: firebird-support@yahoogroups.com
Subject: Re: [firebird-support] Selectable or not ?


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

Yahoo! Groups Links