InfoPath Dev

Hi,

I am using InfoPath 2007.

I have a form with a repleating field.  I have set up some validation to check for duplicates in the list. The field is called Aliases and the validation is...

. = preceding-sibling::my:Aliases

and

. = following-sibling::my:Aliases

This works brilliantly - thank you for previous blogs and posts which helped me get that right. 

I am shredding the data to SQL where it is part of a primary key.  In SQL a value "xyz"  is considered the same as "XYZ" so I need to do something to prevent those "duplicate" values.

So I have added the following  validation

 translate(., "ABCDEFGHIJKLMNOPQRSTUVWXYZ", "abcdefghijklmopqrstuvwxyz") = translate(preceding-sibling::my:Aliases, "ABCDEFGHIJKLMNOPQRSTUVWXYZ", "abcdefghijklmopqrstuvwxyz")

The problem here is that translate() will only be applied to the first preceding or following sibling, and the validation would only work if the duplicates were right next to each other.

You can use eval() to apply a function across all nodes in a set, and it should work here.  Please try this:

translate(., "ABCDEFGHIJKLMNOPQRSTUVWXYZ", "abcdefghijklmnopqrstuvwxyz") = xdMath:Eval(preceding-sibling::my:Aliases | following-sibling::my:Aliases, "translate(., 'ABCDEFGHIJKLMNOPQRSTUVWXYZ', 'abcdefghijklmnopqrstuvwxyz')")

Note that having the preceding-sibling::my:Aliases | following-sibling::my:Aliases like that allows you to combine this into one expression.

That is brilliant THANK YOU. 

This works a treat. 

Have a great weekend

Catharine