Skip to Content
avatar image
Former Member

Carriage return

<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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

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

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

    Add comment
    10|10000 characters needed characters exceeded

    • 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.'