Skip to Content
0

Carriage return

Jul 12, 2017 at 11:10 AM

71

avatar image
Former Member

<br><div id="inner-editor"></div>I try to create an alert with the message on two lines.

Example: :

'Alerte, SAP/MariProject sera clôturé le 5 du Mois.

Merci de mettre à jour vos travaux en cours'

I have not found a solution

request :

Select 'Alerte, SAP/MariProject sera clôturé le 5 du Mois. Merci de mettre à jour vos travaux en cours' as Message from DUMMY

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

avatar image
Former Member Jul 16, 2017 at 09:09 PM
1

Not sure if it will work in SQL but try using CHAR(13), which is carriage return. Or CHAR(10)

Show 3 Share
10 |10000 characters needed characters left characters exceeded

If it does, the query would look something like this:

Select 'Alerte, SAP/MariProject sera clôturé le 5 du Mois.' + CHR(10) + 'Merci de mettre à jour vos travaux en cours' as Message from DUMMY

0
Former Member

Could not execute 'Select 'Alerte, SAP/MariProject sera clôturé le 5 du Mois.' + CHR(10) + 'Merci de mettre à jour vos ...' SAP DBTech JDBC: [328]: invalid name of function or procedure: CHR: line 1 col 63 (at pos 62)

0
Former Member

Could not execute 'Select 'Alerte, SAP/MariProject sera clôturé le 5 du Mois.' + CHAR(13) + 'Merci de mettre à jour ...' SAP DBTech JDBC: [339]: invalid number: not a valid number string 'Alerte, SAP/MariProject sera clôturé le 5 du Mois.'

0