It may be a but of work but could you add an active link (I assume the search is run by clicking a button) that performs a REPLACE for each of the keywords?
The active link would have multiple actions, one for each keyword. Like so: Action 1: Set Field X = REPLACE ($X$,"$NULL$","$\NULL$") Action 2: Set Field X = REPLACE ($X$,"$USER$","$\USER$") etc. --- J.T. Shyman _____ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Jose Rodriguez Sent: Wednesday, August 27, 2008 7:09 AM To: arslist@ARSLIST.ORG Subject: Re: Escape Keywords ** Thank you Joe, the problem is that they don't want to pick up the fields from menus, they just want to copy the advanced search from a certain Form and paste it in the "Advanced Searches Registry Form", and I need to translate it into "qualification" format. Regards, Jose On 8/27/08, Joe DeSouza <[EMAIL PROTECTED]> wrote: ** How about building a menu of keywords where the value has the \ and the label does not.. Joe ----- Original Message ---- From: Jose Rodriguez <[EMAIL PROTECTED]> To: arslist@ARSLIST.ORG Sent: Wednesday, August 27, 2008 3:15:57 AM Subject: Escape Keywords ** Hello Listers, my customer wants to use a Display-Only Form with a Table Field to see the results of the Advanced Search that he selects. The customer populates a Regular Form with: Advanced Search, Name and Description and we have the workflow to translate the labels into names and store it in a Field via special commands: "Application-Parse-Qual-L" and "Application-Format-Qual". We use this Field (Translated Advanced Seach) in the qualification of the Table Field via External. The problem appears when they use the "Keywods". ARS translate it, and when they write "Field_1" = $NULL$ they get the error "ARERR [2294] A field or value expected at this position" . To solve that, it's necesary to use the escape character "\". With the escape character, everything works fine, but they don't want to manualy modify the Advanced Search. Is there another way to escape the keywords before ARS use them?. ARS 7.1 WIN 2003 Oracle 10 Regards, Jose Rodriguez __Platinum Sponsor: www.rmsportal.com <http://www.rmsportal.com/> ARSlist: "Where the Answers Are" html___ __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" html___ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
