PDA

View Full Version : Title Expressions - Case Sensitive


ashwken
07-09-2008, 09:26 AM
It would appear that Attribute Names are case-sensitive when used in Title Expressions.

This expression generates a SYNTAX ERROR:

trim(coalesce(
[Ev_Date] || ' - ' || [Ev_Type] || ' - ' || [Ev_SubType] || ' - ' || [Ev_MoreTitle],
[Ev_Date] || ' - ' || [Ev_Type] || ' - ' || [Ev_SubType],
[Ev_Date] || ' - ' || [Ev_Type] || ' - ' || [Ev_MoreTitle],
[Ev_Date] || ' - ' || [Ev_Type],
[Ev_Date],
'(Lead Event)'
))

This Attribute is actually named [EV_MoreTitle], renaming this Attribute to match the case shown in the expression corrected the error.

kinook
07-10-2008, 01:57 PM
Yes, it is currently case sensitive. We'll flag this to match case insensitively in a future release.

ashwken
07-10-2008, 02:51 PM
Sounds good.

This had me scratchin' my head for a while.