Progress
Report Builder
User’s Guide
Case Sensitivity
Case sensitivity affects calculated fields in two ways:
How Operators and Functions Case Sensitively Process Data
Operators that process character string values do not apply case sensitivity unless one or more of the operands is case sensitive. This applies to operators, such as greater than (>), that compare character values but do not return them.
Built-in functions do not apply case sensitivity unless one or more arguments is case sensitive. This includes the IIF and CASE functions. If any argument passed to one of these functions is case sensitive, Report Builder processes the whole expression case sensitively.
How Report Builder Determines the Case Sensitivity of Expression Results
Report Builder determines the case sensitivity of expression results by determining:
- The case sensitivity of the result of a whole calculated field based on the setting of the case-sensitive toggle box. If the case-sensitive toggle box is not checked, the calculated field result is automatically case-insensitive. If the case-sensitive toggle box is checked Report Builder must determine the natural case-sensitivity of the expression.
- The case sensitivity of all subexpressions within a whole calculated field
- Operators that return character values return a case-insensitive value unless one or more of the operands is a case-sensitive string.
- The result of a built-in or user-defined function is case sensitive only when it returns a character string value and it has at least one argument that is case sensitive. The only exceptions to this rule are the IIF and CASE functions, whose return values match the case sensitivity of the value chosen for return.
If the database field in a calculated field expression is case sensitive the result of the subexpression is also case sensitive.
For example, in the calculated field expression:
If fname is a case-sensitive database field then the result of the sub-expression SUBSTRING (fname, 1,5) is also case sensitive. The natural case sensitivity of SUBSTRING (fname, 1, 5) + lname is therefore also case sensitive.
- When Report Builder evaluates an expression and one of the elements of the expression is a reference to a character field, Report Builder determines the case sensitivity of the that field according to the rules in the following table:
See "Fields," for a complete description of how Report Builder handles case sensitivity.
Copyright © 2004 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095 |