Carriage Return Problem In SQL

[jmccolley]

I am using a text area dtc in Visual Interdev. When I type into the text area and press "Enter" the cursor moves to a new line but when the text is saved to the SQL 7 database the carriage return is not saved. When I read the data back in to print in a report the carriage returns are lost. Is there a way to save carriage returns to SQL? Is this a question better left for the Visual Interdev forum?

Thanks!

 

[rac2]

It might be an HTML question. Try this.

<TEXTAREA NAME=&quot;comments&quot; WRAP=&quot;hard&quot;>

This will tell the browser to send CR-LF characters to the server when submitting the form.