Thank you / Jim
>>Tore --
>>
>>Is SYS(2015) guaranteed to always return distinct names?
>>
>>Jim
>>
>>
>>>Hi James,
>>>
>>>maybe you can name your cursors according to the level of recursing? Something like
>>>lcCursorname=lcCursorname+'1'
>>>Select * from sometable into cursor (lcCursorname) where bla-bla-bla
>>>Just an idea..! :-)
>
>On the same machine, yes. If you need it just for the internal names within the app (i.e. not filenames) then just go for it. If several machines may create files where sys(2015) is used for generating filenames, there's a one-in-a-trillion (or so) chance that they may hit the same value, that's when you should add machine-specific prefix before or after the sys(2015) to make sure it's unique.
>
>As for the recursive selects, I've done it for years, just go for it. It's so much simpler to work with cursors (or at least requires less typing :). I've done multilevel assembly lists on FPD2.6 using recursive selects some nine years ago, and it was damn fast, even on a (then) low-grade 486.
Jim Nelson
Newbury Park, CA