Skip to main content
  • Home
  • Forums
  • Developers Forum
  • How to write update query if column name contains special character? I have used below query but its throwing syntax error "Update [Zahlungsfreigabe_tracking$$] set [1.Erinnerung] ='X' where [P-Bereich] ='$strP-BereichNo$';"
How to write update query if column name contains special character? I have used below query but its throwing syntax error "Update [Zahlungsfreigabe_tracking$$] set [1.Erinnerung] ='X' where [P-Bereich] ='$strP-BereichNo$';"

Hi @Poonam Pandire​ ,

 

You have to edit the headers.

Tell the business users that they have to provide headers, and that the only special character they can use is underscore(_).

 

Kind Regards,

Ashwin A.K

Thanks @Ashwin A.K​ 

Reply


Terms & ConditionsCookie settings