I am trying to perform an SQL expression within the MakeFeatureLayer_management tool on a dataset stored in the "in_memory" workspace, like this...
arcpy.MakeFeatureLayer_management("in_memory\\resourceOL", "in_memory\\resourceOL_layer", "\"landuse\" = 0")
But this isn't working. I've also tried '"landuse" = 0', which didn't work either. However, when I run the "Make Feature Layer" tool from the System Toolboxes, it works fine. My current work around is to use arcpy.UpdateCursor() to delete rows where values in landuse != 0.
So, my questions are:
a) Am I doing something obviously wrong (e.g., syntax)?
b) If not, has anyone else experienced this?
c) If so, is this a bug within the arcpy module?
I am new to the forum, so I apologize if this has already been discussed (I wasn't able to find anything in a quick search).
Thank you,
Chris Karstens