>>>This following does not output the memo fields. How can I get a text file of every field value in a table?
>>>>
>>>>>>>>SELECT * from MyTable TO FILE MyFile.txt
>>>>
>>>
>>>Instead of directly selecting into the textfile, did you try creating a cursor first, followed by COPY TO?
>>
>>I try,but
>>COPY TO ...
>>COPY TO ... sdf
>
>One thing that might be tried is to first select into a cursor, that contains character fields instead of memo fields. Of course, this is limited to 254 characters, I think it was.
>
>Another option is to write your own loop to output the text, and use commands like ?/??, TEXTMERGE, etc.Hi Hilmar,
this question is from Jay Johengen, not from me. I post that the command COPY TO... don't perform good results when in table or cursor is memo field.
_______________________________________________________________
Testing displays the presence, not the absence of bugs.
If a software application has to be designed, it has to be designed correctly!
_______________________________________________________________
Vladimir Zografski
Systems Analyst