Liveware Publishing Support Forum

For a ^text^ field type in a table on our SQL Server, we noticed that it is ignoring a single Carriage Return (CR) and Line Feed (LF) unless there is a pair of them. Is this intended to work this way?____For example, a field containing a single CR/LF and displaying:__First line break here!__Next Line.____It prints the text as:__First line break here!Next Line____However, if the field contains a pair of CR/LF^s and displays:__First line break here!____Next line.____It prints the text correctly as:__First line break here!____Next Line____I^ve verified in Query Analyzer using the ASCII() function that a CR and LF exist. And unless their is a pair of them, R&R is ignoring them.____Using the R&R 10 Build 10.1.003.

In your RSW.INI file (it is in the Windows directory) add a section named SPECIAL (it needs to be enclosed in square brackets) and beneath it add the line:__CharRaw=1____and see if this helps.____Kathleen__R&R Support

Yes, that worked...but now it prints a square block at the end of each line.

Try using__AsciiEditor=0____In place of the CharRaw line and see if that does the trick.____Kathleen__R&R Support

Yes Kathleen, that did the trick. Thanks.____I would think that people would have seen something like this before...is this a work-around? __Or is that the intended way R&R SQL works?__

It is actually by design.____Kathleen__R&R Support