Update database records - escape characters & wrong datatype

Stefan Spraakman

• August 01, 2023 12:47

I'm trying to write back to the database on a failure.

The SQL command coming out of Integration looks like:

UPDATE [table]
SET [Message] = N'%LastErrorMessage%', [Status] = 2
WHERE ([Reference] = N'%_Reference%')

There are two things wrong with this:

- The %LastErrorMessage% contains 'single apostrophes' , generating an error from SQL because the string suddenly stops:

SET [_Message] = N'The 'label.btw' print job did not complete due to the following error: 

How can I adjust this?

- The [Reference] field is an Integer, and is also as such recognized in the Database connection. However it's still trying to make it an NVARCHAR apparently. Can that be adjusted?

Thank you!

1

• 

  Stefan Spraakman

  ★ BarTender Hero ★

  • August 24, 2023 13:12

  Anyone please?

  0
• 

  Peter Thane

  ★ BarTender Hero ★

  • August 25, 2023 09:56

  You may want to raise a Support Query for this and see if they can help out directly rather than use this user forum. It is not something I have had done before, sorry.

  0
• 

  Stefan Spraakman

  ★ BarTender Hero ★

  • August 25, 2023 10:24

  Thanks Peter, just did so.

  0

Please sign in to leave a comment.