5 Replies Latest reply: Apr 5, 2010 4:12 AM by Johannes Sunden RSS

    Escaping single quotes in set expression field values

      I have developed an application which caches selections in the form of a set expression.

      It seems to work fine, except when I have a string value with a single quote ['] character in it.

      It's possible to escape this character by changing it to two single quotes [''], as is the case with SQL, but this results in the value not being properly recognized.

      In the end, the solution I came up with is to use the apostrophe character [`] as the string delimiter. This works fine - as long as my text has no apostrophes in it.

      I was also thinking of using double quotes ["] but this invokes a search query which is not necessary, since I know the values.

      Anyone know of any solutions?