Re: Stored procedures

Jack Parker wrote: > > > 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. > > 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. Yes true. We used FETCH ABSOLUTE for this and assumed the reopened cursor contained the same record set. > 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. It can, but as to a working example, I don't have one on me right now. :-) However, If I get time this week (ha ha) I'll knock one up for you. I am sure this is easier in SPL now, but in those days we only had 4GL. ;-) With reference to Mike Ack's post, I agree. SPL IS the place for business rules, just don't put the whole application in there. ;-) Cheers, -- Mark. +-------------------------------------------------------------------------+ |Mark D. Stock - The West Solutions Group http://www.west.co.za | | The Informix FAQ is at http://www.iiug.org | |mailto:marks@west.co.za +------------------------------------------------+ |Tel: +27 11 803 2151 |If it doesn't work... force it! | |Fax: +27 11 803 2189 |If it breaks... it needed replacing anyway! | |Cell: +27 83 250 2325 |Well, that's how I code anyway! | +------------------------+------------------------------------------------+