Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Array : Dimension vs Ains
Message
From
01/02/2000 13:10:37
 
 
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00325376
Message ID:
00325700
Views:
25
>>Adding columns is squirrely - blame the right thing for the evil effects on your data!
>
>Though it may be round-about I prefer VFP's table handling capabilities to it's array handling capabilities. For example, if I wanted to add a column to an array, I would append the array into a cursor, add the column (field) to the cursor then copy the cursor out to an array of the same name. I told you it was round-about but at least I get what I expect.

I have no problem with that - it handles the issue nicely. In most cases where I'd want to add columns or rows on the fly, a cursor or table is perhaps a better medium - the issue of maximum number of total elements is gone, a fieldname is normally more descriptive than a column number reference, and adding columns via ALTER TABLE and rows via INSERT is an attractive alternative. There are some speed issues possibly, and the issue of visibility in multiple data sessions, but in general the advantages seem to greatly outweigh the drawbacks for me.
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
Reply
Map
View

Click here to load this message in the networking platform