ERROR
Note: This article pertains to ArcGIS versions 8.x. Later versions of ArcGIS may contain different functionality, as well as different names and locations for menus, commands and geoprocessing tools.
This error occurs when adding a new feature to a feature class in a personal geodatabase in ArcMap:
Create: An unexpexted failure occured General function failure (_FeatureClass) Syntax error in query expression '(OBJECTID IN (6) ) AND (_FeatureClass.OBJECTID NOT IN (SELECT OBJECTID FROM DELTA _FeatureClass ) )'.
The feature class has a leading underscore (_) in its name. This causes queries used for inserting new features to fail.
Rename the feature class so it doesn't have an underscore as the leading character.
Get help from ArcGIS experts
Download the Esri Support App