SKIP in concatenation

[Pabitha]

Hi,

Im trying to save error message to a database field(character datatype).
eg. "Invalid entity <entity1>" "Invalid entity <entity2>" etc

I have concatenated the messages into the same field. So while displaying it appears as
"Invalid entity <entity1> Invalid entity <entity2>".
Is there any way to display the message in different lines as
"Invalid entity <entity1>"
" Invalid entity <entity2>".

Progress version 9.1D
OS- UNIX

Thanks in Advance.

 

[Cringer]

Not completely sure what you want, but try adding "~n" to your concat.

 

[Pabitha]

I was looking for the same. Thank you

 

[RealHeavyDude]

You can also use CHR(10).

Heavy Regards, RealHeavyDude.

 

[Stefan]

You can also use CHR(10).

Or "~012".