11/22/2024 9:55:45 AM
|
| |
| slxdeveloper.com Community Forums |
|
| |
|
|
The Forums on slxdeveloper.com are now retired. The forum archive will remain available for the time being. Thank you for your participation on slxdeveloper.com!
Forum to discuss general T-SQL questions and help with queries related to SalesLogix data. View the code of conduct for posting guidelines.
|
|
|
|
How to create a new line through sql sever
Posted: 06 Jul 12 6:10 PM
|
fiogf49gjkf0d I am trying to store data in the notes section on SLX, and I am trying to use new line in my notes to make it easier to read. I store data in sql server database, I am trying to use char(10), char(13), "\n"...etc. but nothing seems to work.
Can someone please assist. |
|
|
|
Re: How to create a new line through sql sever
Posted: 07 Jul 12 2:22 AM
|
fiogf49gjkf0d Maybe if you posted the actual SQL you're using...? And could you tell us exactly how it's not working - does it store anything at all, or are you just not seeing the carriage return-linefeeds (CRLFs) in the notes? Maybe you could also tell us what version of SLX you're on, and why you can't use VBscript for this...
I submit an INSERT command like this, directly through the SLX provider:
Insert into History (historyid, accountid, notes, longnotes)
Values ('HSITE0000001', 'ASITE0000001',
'This is a' + CHAR(13) + CHAR(10) + 'note',
'This is a' + CHAR(13) + CHAR(10) + 'slightly longer note')
...and it stores the CRLFs with no problem. You might not actually see the CRLF displayed in the NOTES field if you're looking at it in a datagrid or a textbox, but it's there. |
|
|
|
Re: How to create a new line through sql sever
Posted: 08 Jul 12 10:33 AM
|
fiogf49gjkf0d I second John's response:
SQL will store the new Line Characters. If you are using the LAN client, you will see the line breaks accordingly, however on the Web Client you may not be able to see them (depends on the control they are linked to, etc, etc).
In Datagrids (on the Web Client), it won't display the line breaks (unless you replace them with <br /> tags.... |
|
|
| |
|
You can
subscribe to receive a daily forum digest in your
user profile. View the site code
of conduct for posting guidelines.
 Forum RSS Feed - Subscribe to the forum RSS feed to keep on top of the latest forum activity!
|
|
|
|
|
|
|
|