Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Combining Arrays
Message
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00219637
Message ID:
00219693
Views:
39
>>>>>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...
EMail: EdR@edrauh.com
"See, the sun is going down..."
"No, the horizon is moving up!"
- Firesign Theater


NT and Win2K FAQ .. cWashington WSH/ADSI/WMI site
MS WSH site ........... WSH FAQ Site
Wrox Press .............. Win32 Scripting Journal
eSolutions Services, LLC

The Surgeon General has determined that prolonged exposure to the Windows Script Host may be addictive to laboratory mice and codemonkeys
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform