Jim ..I think I found the reason, it seems that the EXTERNAL function does not work with tablecolumns. I added a set field action to my guide from the tablefield to a displayonly char field, and changed the EXTERNAL function to read this charfield, after that everything works as expected. /L ars
-----Original Message-----
From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG]On Behalf Of O'Hara, Jim
Sent: Friday, December 30, 2005 8:10 PM
To: arslist@ARSLIST.ORG
Subject: Re: What am I doing wrong ..
Lars,
Could you show us the actual contents of columnfield? Maybe there is something in there that is throwing it off. Your email only shows the two field compares, but it doesn't show if they are ANDed together or ORed together.
This is just a bunch of guesses. I see something wrong with all of them, but here goes.
Maybe on table looping the active link always fires. Maybe the active link could call another guide, and the active link in that second guide could have the run if/message action.
Should your criteria say, 'Field2' = "3" (with quotes)? Is it a selection or radio button, where 0 = "1", 1 = "2", 2 = "3", 3 = "4"? Although from your write-up you would need a 4, not a 2, for the criteria to be true (unless 3 = "2"). Is Field2 a real field? Maybe if you used 3.0 instead of 3? But again, 2 should be false.
For debugging, have you tried putting Columnfield into the message?
Jim O'Hara
jlo4@PGE.com
-----Original Message-----
From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of lars.j.pettersson@VATTENFALL.COM
Sent: Friday, December 30, 2005 7:05 AM
To: arslist@ARSLIST.ORG
Subject: Q: What am I doing wrong ..
Hi, maybe I have missed something important, but I guess this should work, but the function returns unexpected result.
I want to check some fields when an al is is executed. I want to make this datadriven, so therefore I have a form where I store the run if critera.
For example:
'Field1' = $\NULL$
'Field2' = 3
A table field shows all the active rows from this form.
I have an al table loopfunction running with run if criteria: EXTERNAL( 'Columnfield')
Errormessage on the if page.
My problem is that the run if critera always seems to be true. If 'Field2' = 2 is in the form, I get the errormessage.
anyone who can see what i am doing wrong?
L ars Pettersson
Vattenfall Business Services Nordic AB
Action Request System Engineer (Tabasco)
S-461 88 Trollhättan
Sweden
Phone +46 520 888 35 Mobil +46 70 608 99 95
e-mail: lars.j.pettersson@vattenfall.com
UNSUBSCRIBE or access ARSlist Archives at http://www.ARSLIST.org
(Support: mailto:support@arslist.org)
UNSUBSCRIBE or access ARSlist Archives at http://www.ARSLIST.org
(Support: mailto:support@arslist.org)
UNSUBSCRIBE or access ARSlist Archives at http://www.ARSLIST.org
(Support: mailto:support@arslist.org)