The Query Builder in the Extract Wizard does not accept left parenthesis in expressions. Attempting to add a parenthesis produces the following message "Left parentheses must follow an item or operator". This message is produced even when the parenthesis does follow an item or operator.Using the keyboard to add the left parenthesis erases parts of the expression.
This is a known issue with ArcGIS 8.1
This Wizard uses the ArcInfo Workstation RESELECT command, which does not allow complex, single-line, bracketed expressions. The RESELECT command requires expressions to be build vertically (multiple lines) and horizontally.
AREA > 500 and (SITE = 'G' OR SITE = 'M'),
Subset AREA > 500
Subset SITE = 'G' OR SITE = 'M'
(age = 1 and height = 3) or (age = 2 and height = 4)
Subset age = 1 and height = 3
Add age = 2 and height = 4
Get help from ArcGIS experts
Download the Esri Support App