This question already has an answer here:
Im trying to create a feature layer on which i want to perform a select by location, however:
arcpy.MakeFeatureLayer_management (perp, "selected","LINK_ID = 23002109")
ExecuteError: ERROR 000230: Failed selecting with LINK_ID = 23002109
arcpy.MakeFeatureLayer_management (perp, "selected") arcpy.SelectLayerByAttribute_management("selected", "NEW_SELECTION", "LINK_ID = 23002109")
ExecuteError: ERROR 000358: Invalid expression
The same query works fine when done manually in ArcMap. The field exists and its datatype is DOUBLE.
My problem seems to be exactly the same as in ArcPy inconsistently accepts SQL queries for MakeFeatureLayer or SelectLayerByAttribute The difference is I'm working with a local GDB and not with a SDE connection. What is wrong here?