Progress
Version 9
Product Update Bulletin
LOGICAL Function
Converts any data type into the LOGICAL data type.
The LOGICAL function has the following syntax:
SYNTAX
expression
An expression in the datatype that you want to convert to logical.
char-expression-format
A character expression that evaluates to a valid logical format, such as "si/no", or "da/nyet". This argument is ignored unless <expression> is of CHARACTER type. Also, this argument is only needed if <expression> evaluates to something other than the usual TRUE or FALSE, or YES or NO values.
EXAMPLE
NOTES
- The LOGICAL function returns UNKNOWN if the <expression> is UNKNOWN.
- If <expression> is of type DECIMAL, INTEGER, DATE, or HANDLE, the function returns TRUE if the value of <expression> is nonzero. If the value of <expression> is 0, it returns FALSE. The second argument is ignored if present.
- If <expression> is of type CHARACTER, it returns TRUE or FALSE depending on the value in the expression and the format used. Whether or not <char-expression-format> is given, the case-insensitive values TRUE, FALSE, YES, NO, abbreviated to 1 character, are always accepted. For example, a "Y" is interpreted as TRUE.
If <char-expression-format> is given, it is validated. If it is not valid, an error message appears and UNKNOWN is returned. Otherwise, the format is used to interpret the character string if it is not one of the following: TRUE, FALSE, YES, or NO. For example, LOGICAL ("si", "si/no" ) returns TRUE.
- On Data types such as RAW, MEMPTR, LVARBINARY, and so on, the LOGICAL function returns UNKNOWN, but this is not considered an error.
SEE ALSO
STRING, INTEGER, DATE in the Progress Language Reference .
Copyright © 2004 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095 |