Kbase P117438: How does the 4GL MINIMUM function compare its CHARACTER parameter values?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
20/07/2006 |
|
Status: Unverified
GOAL:
How does the 4GL MINIMUM function compare its CHARACTER parameter values?
GOAL:
Why does the MINIMUM function sometimes return the longest of its CHARACTER parameter?
FIX:
1. The 4GL MINIMUM function returns the value that sorts first in an ascending list of its parameter values.
2. The length of the MINIMUM function parameter values has no bearing on the returned value. If the longer parameter value of the MINIMUM function happens to sort first in an ascending list of its parameters, then the MINIMUM function will return the value of that parameter. For example, the following code returns 'abc' because the parameter value 'abc' would sort first in an ascending list of the two parameters 'abc', 'b':
MESSAGE MIN("abc", "b")
VIEW-AS ALERT-BOX INFO BUTTONS OK.
3. If one or more of the 4GL MINIMUM function parameters is a field defined as case sensitive, then MINIMUM function treats all of the values as case sensitive.
4. If none of the 4GL MINIMUM function parameters is case sensitive, then MINIMUM function treats lowercase letters as if they were uppercase letters.