Skip to Content

SAP Business One Integration to 3rd party Inserting Data using Query

Dear All Experts/Gurus,

I'm getting error when the item description that i gonna added into my table contains an apostrophe symbol (') . it's like VALUES ('M22592-04-04' , '90° SWIVEL FEMALE 37° 1/4' 7/16' 75/box') where my query reads the apostrophe and then it will throw me to the error.here is my code

T

is it possible to use parameter @itemCode or there's other way to resolve this error? thanks in advance

Good Day!

untitled.png (30.7 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Jan 07 at 02:00 PM

    Hi,

    One solution is to replace all quotation marks ' with accents ´

    It will look the same to the human eye, but you do not get the error. This solution also works for the DTW.

    Regards,

    Johan

    Add comment
    10|10000 characters needed characters exceeded