Thanks
>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