Support Forums - View Thread

View Thread

The following is the text of the current message along with any replies.

Messages 1 to 2 of 2 total

Tue, Jun 6 2006 5:23 AM	Permanent Link
SteveW	How do I include a carriage return and line feed in the SQL I send to the ODBC driver. If the string includes Chr(13) or Chr(10) it seems to generate an error.
Tue, Jun 6 2006 12:14 PM	Permanent Link
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com	Steve, << How do I include a carriage return and line feed in the SQL I send to the ODBC driver. If the string includes Chr(13) or Chr(10) it seems to generate an error. >> Use: #13+#10 as in SELECT 'My Test'+#13+#10 FROM MyTable -- Tim Young Elevate Software www.elevatesoft.com