Kbase P100218: Can the special characters used by the CAN-DO function be escaped?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
20/12/2010 |
|
Status: Verified
GOAL:
Can the special characters of the CAN-DO function be escaped to be interpreted as literals?
FACT(s) (Environment):
All Supported Operating Systems
Progress 8.x
Progress 9.x
OpenEdge 10.x
FIX:
The special characters associated with the CAN-DO function can not be escaped. The CAN-DO function was designed for checking permissions and has special meaning for the following six characters:
.: Match a single character
*: Match multiple characters
!: Negate a match
,: Separate matches in a list
#: Distinguish GRANTable vs. non-GRANTable permissions in SQL89.
Using the CAN-DO function as a substitute for the LOOKUP function constitutes a misuse of the CAN-DO function and is strongly discouraged.