Out of curiosity, why are you not doing this with a set fields (or push fields) on a filter or active link?
-----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Koyb P. Liabt Sent: Thursday, September 07, 2006 12:04 PM To: [email protected] Subject: SQL Syntax Hi, I am trying to pass a value into a field on HPD:Helpdesk, and make sure it only updates the current record open. I met with the dba, referenced database guide, and I have this command below, however I am getting failure during SQL operation - invalid character. Does anybody know what is wrong with the syntax below: update T418 set C535478792 = '$Secondary email$' where C1 = '$Case ID+$'; update T418 set C535478792 = "$Secondary email$" where C1 = "$Case ID+$"; update T418 set C535478792 = $Secondary email$ where C1 = $Case ID+$; ARERR [552] Failure during SQL operation to the database : ORA-00911: invalid character ----------------- Forwarded Message: Subj: Re: SQL syntax Date: 9/6/2006 5:04:09 P.M. Eastern Standard Time From: [EMAIL PROTECTED] (mailto:[EMAIL PROTECTED]) Reply-to: ________________________________________________________________________ _______ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org The information in this e-mail, and any files transmitted with it, is intended for the exclusive use of the recipient(s) to which it is addressed and may contain confidential, proprietary or privileged information. If you are not an intended recipient, you have received this transmission in error and any use, review, dissemination, distribution, printing or copying of this information is strictly prohibited. If you have received this e-mail in error, please notify the sender immediately of the erroneous transmission by reply e-mail, immediately delete this e-mail and all electronic copies of it from your system and destroy any hard copies of it that you may have made. Thank you. _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
