Problem Note 13027: Values with parenthesis may cause SQL errors using Enterprise Guide
Data values within parentheses may cause SQL errors when using the Query
Builder in Enterprise Guide. This will most likely occur when using the
Filter interface to add column values with parentheses to the value list
for the IN operator.
To circumvent the problem, manually enter the values. For example,
('(first value with parentheses)', '(second value with parentheses)')
A Technical Support hot fix for this issue is available at:
http://www.sas.com/techsup/download/hotfix/ent_guide30.html#013027
Operating System and Release Information
| SAS System | SAS Enterprise Guide | Microsoft Windows 2000 Professional | 2.0 | 3.0 | 9 TS M0 | 9.1 TS1M0 |
| Microsoft Windows XP Professional | 2.0 | 3.0 | 9 TS M0 | 9.1 TS1M0 |
| Microsoft Windows NT Workstation | 2.0 | 3.0 | 9 TS M0 | 9.1 TS1M0 |
*
For software releases that are not yet generally available, the Fixed
Release is the software release in which the problem is planned to be
fixed.
| Type: | Problem Note |
| Priority: | medium |
| Date Modified: | 2004-10-08 15:38:55 |
| Date Created: | 2004-08-10 14:58:49 |
