Subject Re: [ib-support] recursive procedures
Author Jason Chapman (JAC2)
Can't, IB detects the 1000 depth and barfs (as I guess you have found out),
thinking you have gone into an infinite loop.
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)