If you can read Spanish, there are several articles about that topic: https://firebird21.wordpress.com/2013/10/10/stored-procedures-recursivos/
https://firebird21.wordpress.com/2015/08/22/usando-recursividad-con-cte/ https://firebird21.wordpress.com/2015/08/27/ejemplo-de-recursion-1/ https://firebird21.wordpress.com/2015/08/28/ejemplo-de-recursion-2/ https://firebird21.wordpress.com/2015/08/29/ejemplo-de-recursion-3/ https://firebird21.wordpress.com/2015/08/30/ejemplo-de-recursion-4-actualizando-filas-recursivamente/ https://firebird21.wordpress.com/2015/08/31/ejemplo-de-recursion-5-saldos-acumulados/ https://firebird21.wordpress.com/2015/09/05/ejemplo-de-recursion-6-repitiendo-las-filas/ Greetings. Walter. On Wed, Oct 21, 2015 at 6:37 AM, josef.gschwendt...@quattro-soft.de [firebird-support] <firebird-support@yahoogroups.com> wrote: > > > Hi, > > I have a table with hierarchical > data. > > There is a numeric sortfield where the user sets the sort-order of the > children of a particular parent (values from 1 to n für each parent). > > > How can I write a recursive query which selects the whole tree and honors > these sortnumbers. > > > TIA, > > Josef > > >