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?

Regards

Z T Minhas





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