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

    ExecuteSQL French Accented Charecterset

    kamal1234

      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

      Kamal.