4 Replies Latest reply on May 17, 2016 9:23 AM by actualjon

    ExecuteSQL French Accented Charecterset


      Dear Community members,


      I have french accented character set in my update and insert sql statements.

      How can I escape them in ExecuteSQL statement.


      My sample sql statement is


      "update CPD_AreasOfInterest set " &

      "AreaOfInterestDesc='"&VL_AreasOfInterest::AreaOfInterestDesc&"'" &

      " where AreaOfInterestID='"&VL_AreasOfInterest::AreaOfInterestID&"'"


      Thank you