cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Nintex 2010 / SQL-Statement - Insert text with line breaks

Hello,

we are currently using the „Execute SQL“ action to insert multi line text into an Oracle database (plain Insert). In that case, the line break will be removed when building the string in the “Build string” action.

1.jpg

2.jpg

After running the workflow, the line breaks are removed.

3.jpg

4.jpg

When using the TEXT variable as a parameter for the workflow (and removing the Build string action) the line breaks will be transmitted to the database, but with leading spaces at the beginning starting from the second line.

5.jpg

6.jpg

7.jpg

Any ideas?

regards,

Michael

0 Kudos
Reply