Ok, thanks, just wanted to confirm that I'm doing things correctly.

If the sproc ever returned more than one record I'd have problems beyond the
sproc, it'd be a design/application problem.

Thank ya!

-v


_____

From: Woody (TMW) [mailto:woody-tmw@...]
Sent: Sunday, December 12, 2004 1:40 PM
To: firebird-support@yahoogroups.com
Subject: Re: [firebird-support] no suspend on select stored procedure?

>
> I've had people in here tell me that using a stored procedure that selects
> records without a "suspend" command at the end will not return records or

is

> incorrect syntax. I'm not saying you're all wrong but I just came across

an

> example in my application where this is obviously proving that axiom to be
> incorrect.

Your procedure only returns one record so it acts more like a "function".
Whenever you are only returning one set of values, it is not necessary to
use SUSPEND. It is only needed when looping through to return more than one
set of data. However, and someone can correct me if I'm wrong, if by chance
the select ever results in more than one record, it will error.

Woody (TMW)



Yahoo! Groups Sponsor

ADVERTISEMENT

<http://us.ard.yahoo.com/SIG=129fd0gk7/M=298184.5639630.6699735.3001176/D=gr
oups/S=1705115386:HM/EXP=1102969887/A=2434971/R=0/SIG=11eeoolb0/*http://www.
netflix.com/Default?mqso=60185400> click here

<http://us.adserver.yahoo.com/l?M=298184.5639630.6699735.3001176/D=groups/S=
:HM/A=2434971/rand=224350599>

_____

Yahoo! Groups Links


* To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/


* To unsubscribe from this group, send an email to:
firebird-support-unsubscribe@yahoogroups.com
<mailto:firebird-support-unsubscribe@yahoogroups.com?subject=Unsubscribe>


* Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service
<http://docs.yahoo.com/info/terms/> .




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