Saving carriage returns in text fields

Classic Servoy
1

I have a text field in one MS SQL Server database that when displayed as ‘TEXT_AREA’ is nicely formatted in Servoy as follows:

LYMPH NODE

FOLLICULAR GRADE TWO

6/7/2006

I want to be able to first move it to a global variable and then insert it into an Oracle database keeping the formatting of the ‘carriage returns’. I know those aren’t real return characters but whatever I do it seems to lose that formatting. Can anyone give me a clue how to do it? Haven’t really done anything quite like it before. Also would like to be able to concatenate two fields in one with a carriage return in between the two erstwhile fields but the normal Javascript " + ‘\n’ + " doesn’t seem to work for that either when putting it into an Oracle text field nor does it seem to work when copying the results out of the Servoy debugger. Any help greatly appreciated :)

2

I think \n is only a new line character.

What you need is: “\n\r” or “\r\n”

The \r is the return character.

Paul

3

Thanks, Paul. In fact I had tried ‘\r’ and that didn’t seem to work either. In fact though they both work! :oops: I had only checked it in the debugger without actually doing the insert into Oracle from the global variable. I was just using the debugger to check the contents of the global. I guess the debugger strips those out for display purposes but they are actually in the global and then also get inserted into the database and display properly when setting the column as ‘TEXT_AREA’. Note to self: don’t be so lazy and just try to check it in the debugger to see if something works!