Is This Content Helpful?
We're glad to know this article was helpful.
Viewing an attribute table with a column named 'GROUP' fails when using a file geodatabase table.
An error similar to the following statement is returned:
"An invalid SQL statement was used. [SELECT OBJECTID, NAME, group, id, ORIG_FID FROM testFeatureClass WHERE OBJECTID in (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20)]"
The SQL statement includes the reserved word GROUP. GROUP is a reserved word in most RDBMS (ArcSDE), but only became a reserved word at ArcGIS 10.1. Reserved words cannot be used for field names and table names.
Rename the field to something other than a reserved word (GROUP).