Subject Re: [firebird-support] Problem returning multiple rows from a CTE-recursive procedure
Author Steve Naidamast
Post date 2018-05-04T16:31:52Z

How so?  The "SUSPEND" statement is the last statement in the procedure or are you referring to the fact that it is continued as a result of the previous "DO" statement?


Steve



From: firebird-support@yahoogroups.com <firebird-support@yahoogroups.com> on behalf of Dimitry Sibiryakov sd@... [firebird-support] <firebird-support@yahoogroups.com>
Sent: Friday, May 4, 2018 12:25 PM
To: firebird-support@yahoogroups.com
Subject: Re: [firebird-support] Problem returning multiple rows from a CTE-recursive procedure
 
04.05.2018 18:13, Steve Naidamast blackfalconsoftware@... [firebird-support] wrote:
> If you look at my procedure below, you will note that there is only a single "SUSPEND"
> statement.

   If you look a little more, you'll see that it is called in a loop.


--
   WBR, SD.


------------------------------------

------------------------------------

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Visit http://www.firebirdsql.org and click the Documentation item
www.firebirdsql.org
Firebird SQL: The true open-source relational database

on the main (top) menu.  Try FAQ and other links from the left-side menu there.

Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
------------------------------------

Yahoo Groups Links

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

<*> Your email settings:
    Individual Email | Traditional

<*> To change settings online go to:
    http://groups.yahoo.com/group/firebird-support/join
    (Yahoo! ID required)

<*> To change settings via email:
    firebird-support-digest@yahoogroups.com
    firebird-support-fullfeatured@yahoogroups.com

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

<*> Your use of Yahoo Groups is subject to:
    https://info.yahoo.com/legal/us/yahoo/utos/terms/