Re: SQL syntax

[lars . j . pettersson]

** I guess that You need ' for char fields   update T418 set C535478792 = '$Secondary email$' where C1 = '$Case ID+$'   Are You using this code in workflow? T418 will be changed on another server, or if the form is deleted and reimported.to the same server. Use viewnames instead, or avoid hardcoded T no. /L ars -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED]On Behalf Of Koyb P. Liabt Sent: Wednesday, September 06, 2006 10:56 PM To: arslist@ARSLIST.ORG Subject: SQL syntax ** Hi,     I am trying to update a field (C535478792) with the values on the screen from the field $Secondary email$ and pushed directly via SQL into the Help Desk case record I am currently in.   Is this syntax correct?   update T418 set C535478792 = $Secondary email$ where C1 = $Case ID+$; __20060125_______________________This posting was submitted with HTML in it___ __20060125_______________________This posting was submitted with HTML in it___