ItemIf function not working?

PatrickT · Post by **PatrickT** » 07 May 2009 15:29

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

YouTube · Post by **Jane** » 09 May 2009 10:11

Not sure on that one.

JonAxtell · Post by **JonAxtell** » 11 May 2009 08:43

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.

YouTube · Post by **Jane** » 11 May 2009 09:08

I have passed this to Calico for a fix

Family Historian User Group