AnsweredAssumed Answered

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

Question asked by mbrandt on Mar 3, 2015

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

 

Outcomes