Re: Stored procedures

> > Jack Parker wrote: > > > > > > 4 - They are nice to do recursion like when you want to explode a > > bill of materials. Something that 4gl cannot do. > > > > Yes. You miss-spelled 'can' in point 4, it does not end in 'not'. ;-) > 4GL functions do support recursion, and I have used 4GL to print bill of > material type reports. > > My rule for 4GL has always been: > > If it's related to a database, 4GL can do anything. > > Still waiting for someone to prove me wrong. ;-) > The problem lies in re-opening a cursor which is already open from the previous incarnation of the recursive function - 4gl blows up at this point SPL does not. It can be done in 4gl - just not in a recursive manner. If you have a working recursive BOM explosion in 4gl I'd love to see it. cheers j. ________________________________________________________________________ Jack Parker - Hewlett Packard, DMD/IS Boise, Idaho, USA (x65388) jparker@boi.hp.com Currently on loan to CTSB/DTC ________________________________________________________________________ Outside of a dog a book is a man's best friend. Inside of a dog it's too dark to read. (Groucho Marx) ________________________________________________________________________ Any opinions expressed herein are my own and not those of my employers. ________________________________________________________________________