>>Ah...thanks. That's an odd stipulation.
>
>ALTER TABLE creates a free temp table which would cause long name truncation.
Figured it had something to do with free tables.
>
>>
>>Still not sure why someone would need to ALTER a cursor. Can you think of a scenario?
>
>There's no easy way to add Integer or Memo field to the list of query fields. In VFP9 it can be done with CASE() function.
I usually create a temp cursor with an int and/or memo field, and use that in the SELECT to get those data types.
But of course you already know that trick :)
Steve Gibson