Jim,

>'If your only purpose is to add fields to the result you can do that within the SELECT syntax.'

Tell me a select clause which add a general (g) field to a cursor and i'll embrace the 'into table' clause. But i suggest to you see the Cetin's solution: 'alter table' with the cusor alias, no with the table name.
Best regards,
carlos



>Carlos,
>
>Perry and Nancy are correct in their advice. You have been and are depending on an undocumented side effect which can fail at any time. If you need an actual table as the result of your select then select into a table.
>
>The help file is mnisleading when it says that there will be a dbf on disk. Your DBF() function is telling you what name the dbf will get when the result set is large enough to require a dbf. The use agin trick is no longer needed in VFP. You can use an updatable view istead, or you can select into table.
>
>You have encountered the reason that USE AGAIN is not a good solution for creating modifiable tables. If your only purpose is to add fields to the result you can do that within the SELECT syntax.
>
>SELECT Field1, Field2, 000.00 AS Balance ... INTO CURSOR MyResult
>
>Of course the cursor will be read only as it should, change the code to;
>
>lcTable = SYS(2015)
>SELECT Field1, Field2, 000.00 AS Balance ... INTO TABLE (lcTable)
>
>will give you an updatabel table as the result.