The reason is because if you want a double-quote inside a string you use 2 double-quotes together "'LISTSummary' LIKE ""%""+ $Details$ +""%""" (The ones in red become single double-quotes) You may want to check out page 488 of the Basic 6.30 guide for more on building a qualification in a string. Fred
________________________________ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Chris Moore Sent: Monday, May 14, 2007 1:26 PM To: [email protected] Subject: Re: Auto reformatting of a string when Adding Action to Active Link ** Thomas, Thanks for the reply- that got it! For future reference, why did that make a difference? Chris On 5/14/07, Thomas Bean < [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> > wrote: Try doubling up on the double-quotes within the string. For example: " 'LISTSummary' LIKE ""%""+ $Details$ +""%"" " HTH, Thomas ----- Original Message ----- From: "Chris Moore" <[EMAIL PROTECTED]> Newsgroups: gmane.comp.crm.arsystem.general To: < [email protected] <mailto:[email protected]> > Sent: Monday, May 14, 2007 11:22 Subject: Auto reformatting of a string when Adding Action to Active Link Hey everyone- I'm still working on this search form and when creating the Active Links my set fields action is giving me trouble. I am trying to set a field to the following: " 'LISTSummary' LIKE "%"+ $Details$ +"%" " However, when I press "Add Action", it 'corrects' it to: ( "'LISTSummary' LIKE " % "+ $Details$ +") % "" The first string works when I insert it manually into the field. I'm able to search the other form and return what I want. The second does not work if manually inserted. If I allow the active link to run, doing a set fields with the 'corrected' string, I get a message stating ARERR [312] Data types are not appropriate for arithmetic operation and the field is not set to anything. If I try using Advanced options in creating the Active Link, I get an error when I try and set the fields equal to "'LISTSummary' LIKE "%"+ $Details$ +"%"" stating that Valid field/values must be used. I know I'm missing something obvious here. Can anyone let me know how to make this work? Chris ________________________________________________________________________ _______ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are" __20060125_______________________This posting was submitted with HTML in it___ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
