Angus, Do you want to check for 'digits' equal to null or 'digits' equal to "". They are not the same thing.. Null is when there is no value (absence of value) in the character field and "" is a value - its just empty. Most databases recognize the difference.. You would need to check with your database what is applicable..
Cheers Joe -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org]on Behalf Of Angus Comber Sent: Saturday, June 05, 2010 4:40 PM To: arslist@ARSLIST.ORG Subject: Re: Active link Else Action not working ** Hi Chintan Same effect even if I remove the Run If. I think that it means that it will only run the active link if there is text in the digits field. Then applies the if test and I assumed if the If test fails it would execvute tyhe else - but for some reason it does not :( I can't understand why it won't execute the Else. Is there another way to do this? Angus ----- Original Message ----- From: Chintan Shah Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORG Sent: Saturday, June 05, 2010 8:46 PM Subject: Re: Active link Else Action not working ** Hi Angus, " if the qualification does not find any match" -->Where are you checking this part? in "Run If"? If I understand your question correctly, then this 'digits' != "" is not equal to "Employee not found". If if I input a number which does not exist in database digits field is still not empty and hence 'digits' != "" will not fail, in which case "If" action is executed and "If No Requests Match: Do Not Show Any Message and suppress empty list." happens. In other words, the only time I see your "Else" action getting executed is when there is no data entered in digits field (as per Run If that you have provided here). Correct me if I am wrong in understanding your question. Thanks, Chintan --- On Sat, 6/5/10, Angus Comber <arsl...@iteloffice.com> wrote: From: Angus Comber <arsl...@iteloffice.com> Subject: Active link Else Action not working To: arslist@ARSLIST.ORG Date: Saturday, June 5, 2010, 8:58 AM ** Hello I have a button on a form which fires an active link which is configured like this: 1. active link named processdigits. Run if 'digits' != "" and execute on button (on my form). 2. If action tab, action=Open Window, window type=Modify, Display Type=Detail Only, Form name=employees Qualification 'employeeid' = $digits$ If No Requests Match: Do Not Show Any Message and suppress empty list. The If Action part works fine. In the Else Action Tab I have: Current Action=Open window Window Type=Submit Form name=employees Field mapping employeeid mapped to $digits$ My problem is that the Else Action never gets called. So, if the qualification in the If Action finds a match then this executes ok and I see the found employee ok. But if the qualification does not find any match then the Else Action is not executed. What am I doing wrong? Angus _attend WWRUG10 www.wwrug.com ARSlist: "Where the Answers Are"_ _attend WWRUG10 www.wwrug.com ARSlist: "Where the Answers Are"_ _attend WWRUG10 www.wwrug.com ARSlist: "Where the Answers Are"_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"