If you like it clean there must be a way. just a function ?
But there are so many string operators in foxpro I lost track. Look also for TEXTMERGE().
Agnes
>...and my code was so 'clean'. Bad things happen :)
>
>Thanks for help to all.
>
>
>>Christian,
>>SET MEMOWIDTH influenced TEXT but if you look at SET MEMOWIDTH's Help you will see it is not mentioned. In TEXT..ENDTEXT as well. it looks like you need to cut it in peases by your own.
>>
>>Agnes
>>>>>Hello,
>>>>>
>>>>>I use the following code:
>>>>>
>>>>>
>>>>>SET MEMOWIDTH TO 50
>>>>>SELECT MyTable
>>>>>SCAN
>>>>>TEXT TO lcInfo TEXTMERGE NOSHOW
>>>>><<REPLICATE("=",50)>>
>>>>><<MyTable.Memo1>>
>>>>><<REPLICATE("=",50)>>
>>>>>ENDTEXT
>>>>>ENDSCAN
>>>>>
>>>>>
>>>>>What happens is, that if the memo field is very large, the text does not brake by column 50 as I expected to. SET MEMOWIDTH does not influence the line brake.
>>>>>
>>>>>What can I do that the memo field brakes the lines at a certain line length?
>>>>
>>>>Add CHR(13)+CHR(10) at the end of the line and see if you get your breaks.
>>>
>>>
>>>I cannot change the contents of the memo field. It does not have breaks (note: correct spelling here).
>>>I only want to have the breaks in the file that I create from the memo's.
>>>
>>>In FoxPro 2.6 I SET MEMOWIDTH TO 50 and print to file with "?".
Words are given to man to enable him to conceal his true feelings.
Charles Maurice de Talleyrand-Périgord
Weeks of programming can save you hours of planning.
OffThere is no place like [::1]