Page 1 of 1

ItemIf function not working?

Posted: 07 May 2009 15:29
by PatrickT
I can't get the ItemIf function to work at all in queries. For example, trying to set a column to

=ItemIf(%INDI.SEX% = 'Male',%INDI.SEX%,%INDI.SEX%)

returns an error message. I know it doesn't do anything meaningful, but it should work, shouldn't it?. [BTW I've also tried =DataItemIf() which is what the FH help file shows as the function name]



ID:3679

ItemIf function not working?

Posted: 09 May 2009 10:11
by Jane
Not sure on that one.

ItemIf function not working?

Posted: 11 May 2009 08:43
by JonAxtell
Even using the example text in the help doesn't work (even adjusting the for the basic mistake of correcting the function name). Either the program has a bug or the help text needs fixing.

Whilst that's being fixed the link to the ItemIf help item from the Conditional Expressions help item needs fixing as it points to the TextIf help item instead.

ItemIf function not working?

Posted: 11 May 2009 09:08
by Jane
I have passed this to Calico for a fix