>>>>>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 :)
There are a few places where an array is more useful; open cursors don't cross data session boundaries terribly neatly, and there are many non-VFP COM objects that take an array as input but would have no clue about handling a cursor reference, or a DBF table.
But in general, there are more arguments against arrays than for them...