Z T Minhas ha scritto:

> Hi,
>
> I am using a self referencing table in which i am trying to find the level of a field from its parent field. I know that Oracle allows for connect by and prior. Is there something similar in firebird? If not, I already have a recursive stored procedure which gets all the data that I need but it does not calculate the level correctly. Any help?
>

There were few days ago (03 Apr 09) a thread about recursive query in
Firebird 2.1+
Subject of the thread was an not so clear "help with a select, please!",
but argument is use of WITH [RECURSIVE] ... SELECT ... and there are
addressing to a good paper presented in Bergamo. See:
http://tech.groups.yahoo.com/group/firebird-support/message/101355.

For summary, you can see Release Notes on FB 2.1
Ask here with a sample of what you are trying to obtain, if this doesn't
help you.

Ciao.
Mimmo.