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!
|
|
How to insert a carriage return and/or line feed into a text string using VBScript so SLX memo shows it correctly?
Posted: 03 Jan 08 12:09 PM
|
Does anyone know how to insert a CR or LF into a text string in a VBScript (which is writing data directly to the SQL tables) so that SLX will interpret it properly in a memo control?
I put the VBScript chr(10) & chr(13) into the string, but in the SLX memo control the string data shows a thick black line in the string where the line return should be.
I do have the property "WantReturns" enabled for the memo control so users are allowed to enter returns in the text, and this does work when the text is entered through the client directly in the control. The raw SQL data shows 2 spaces in the string where the return is, but somehow SLX magically knows to make this a line return in the memo control. Inserting raw SQL data with 2 spaces shows in the memo control as 2 spaces (which I would expect).
Any ideas on how SLX reads a SQL string from the database and knows when to insert a line return?
|
|
|
| |
|
Re: How to insert a carriage return and/or line feed into a text string using VBScript so SLX memo shows it correctly?
Posted: 03 Jan 08 12:25 PM
|
Hi Ted.
Yes I have done that and it does work to insert the CR/LF into the text string and it stores it in the SQL table, but the problem is that the SLX memo control in the client doesn't interpret it right - the memo control shows either one or two thick black vertical lines where the CR & LF should be.
I'm hoping there is some other method or some "magic" trick for either using some other VB code to insert the returns into the string in the SQL table or some way to make the SLX client memo control interpret them correctly.
Mark |
|
|
| |
| |
|