Boris,
Thanks!
There are quite a number of fields in the table. Is there an easy way to construct the FieldListWithoutMemo, other than doing it by hand?
Yossi
>>Hi All:
>>
>>How can I COPY to another table, FOO, but handle the memo fields in the following possible ways:
>>
>>1. Exclude any memo fields
>
>
>COPY TO Foo FIELDS EXCLUDE MemoFieldName
>
>
>
>>2. Convert the memo fields to character fields in the output table and just copy the first 255 characters
>
>
>SELECT FieldListWithoutMemo, CAST(MemoFIeld AS C(255)) AS MemoFieldName INTO CURSOR crsTest
>COPY TO Foo
>
>
>>
>>I realize I can do this with some programming, but is there a simpler way?
>>
>>Why do I want to do this?
>>
>>Because I want to COPY to a text file for a user and also provide the user with the structure of FOO that matches the text file. I've discovered that VFP ignores memo fields when COPYing to a text file.
>>
>>Thanks,
>>
>>Yossi