>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,
Here's an example of adding a general field with SELECT.
CREATE CURSOR Temp (MyGen G)
APPEND BLANK
SELECT Field1, Field2, Temp.MyGen FROM Table1, Temp ...