AnsweredAssumed Answered

ExecuteSQL French Accented Charecterset

Question asked by kamal1234 on May 17, 2016
Latest reply on May 17, 2016 by actualjon

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.

Outcomes