>>>>I might well use this because it's more flexible (if I actually used arrays much anymore :), but how about using AINS, getting loop size from ALEN?
>>>
>>>Sure, but I'm pretty certain that, with large arrays at least, the constant redimensioning, AINS() and population of array members would be slower than simply appending into a temporary cursor and spitting out the end result with a SQL Select. And the cursor is certainly easier to sort or filter, too.
>>
>>Yes, could be a size issue at some point...well, this goes back to what I was saying last week, I guess, that cursors are more flexible than arrays, and are better for most situations. And if you need to do temporary array manipulation with cursors, why not just use cursors, period? :)
>
>'Cause I can't get ADIR() to spit straight into a cursor?
Okay, okay, I mean
after that :)
The Anonymous Bureaucrat,
and frankly, quite content not to be
a member of either major US political party.