If you use
Thor, you will also have SuperBrowse which can be used to select the fields you want to copy.
>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