Rich,

See Re: Adding memo field as calculated field Message #683252


>I have a cursor created via

>SELECT fieldlist FROM myTable WHERE conditions INTO CURSOR myCursor READWRITE

>
>I would like to add a memo field to myCursor but haven't quite figured out the syntax for either ALTER TABLE myCursor (Invalid Operation) or modifying the SELECT statement.
>
>Is there something cleaner than

>SELECT fieldlist FROM myTable WHERE conditions INTO TABLE myTmpTable
>ALTER TABLE myTmpTable ADD newmemofield M
>SELECT * FROM myTmpTable INTO CURSOR myCursor READWRITE
>DELETE FILE myTmpTable.*

>
>Thanks.........Rich