For a select add a suspend; line

CREATE PROCEDURE TestProc
RETURNS (five_val INTEGER)
AS BEGIN
five_val = 5;
suspend;
END;

----- Original Message -----
From: "sperlis" <sperlis@...>
To: <firebird-support@yahoogroups.com>
Sent: Monday, January 14, 2008 8:51 AM
Subject: [firebird-support] Stored Procedures using IBPP


> Hello all,
> I am trying to (learn) to use Stored Procedures in Firebird using
> IBPP. I have added the stored procedure:
>
> CREATE PROCEDURE TestProc
> RETURNS (five_val INTEGER)
> AS BEGIN
> five_val = 5;
> END;
>
> When I execute it, there is no error (i.e. no exception) which I
> assume means "all's well". My question is: where do I see "five_val"?
> I assumed it would appear as a row with a single column, but it isn't
> :-(. Looking at the implementation (statement.cpp) it says "Should
> return at most a single row". Does that mean I can not retrieve more
> than a single row of data?
>
> Until now we've done everything using SELECT queries, so I am quite
> unfamiliar with stored procedures (in Firebird and in general). Am I
> missing something in the procedure itself?
>
> Thanks,
>
>
>
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Visit http://www.firebirdsql.org and click the Resources item
> on the main (top) menu. Try Knowledgebase and FAQ links !
>
> Also search the knowledgebases at http://www.ibphoenix.com
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Yahoo! Groups Links
>
>
>