>>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.