Can't, IB detects the 1000 depth and barfs (as I guess you have found out),
thinking you have gone into an infinite loop.
Q's:
1) How Deep are you likely to need it to go?
2) Does each iteration require new data from tables?
3) What is the nesting for?


Choices are:
1) Tweak FB and rebuild - I would imagine that it is a constant somewhere.
2) Change your algorithm
3) Do it outside FB

Jason Chapman

JAC2 Consultancy



Training - Development - Consultancy

Delphi, InterBase, Firebird, OOAD, Development lifecycle assistance,
Troubleshooting projects, QA.....

www: When I get round to it....

Mob: (+44) 07966 211 959 (preferred)

Tel: (+44) 01928 751088




I need to use recursive procedures which must be nested

> more then 1000 levels deep. How can i do this? (I have 2 databases: for

WinNT and FreeBSD)