topic Issue with SQL Expression using &amp;quot;in_memory&amp;quot; dataset in Python Questions https://community.esri.com/t5/python-questions/issue-with-sql-expression-using-amp-quot-in-memory/m-p/358715#M28313 <HTML><HEAD></HEAD><BODY><SPAN>I am trying to perform an SQL expression within the MakeFeatureLayer_management tool on a dataset stored in the "in_memory" workspace, like this...</SPAN><BR /><BR /><SPAN>arcpy.MakeFeatureLayer_management("in_memory\\resourceOL", "in_memory\\resourceOL_layer", "\"landuse\" = 0")</SPAN><BR /><BR /><SPAN>But this isn't working.&nbsp; I've also tried '"landuse" = 0', which didn't work either.&nbsp; However, when I run the "Make Feature Layer" tool from the System Toolboxes, it works fine.&nbsp; My current work around is to use arcpy.UpdateCursor() to delete rows where values in landuse != 0.</SPAN><BR /><BR /><SPAN>So, my questions are:</SPAN><BR /><BR /><SPAN>a) Am I doing something obviously wrong (e.g., syntax)?</SPAN><BR /><BR /><SPAN>b) If not, has anyone else experienced this?</SPAN><BR /><BR /><SPAN>c) If so, is this a bug within the arcpy module?&nbsp; </SPAN><BR /><BR /><SPAN>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).</SPAN><BR /><BR /><SPAN>Thank you,</SPAN><BR /><BR /><SPAN>Chris Karstens</SPAN></BODY></HTML> Sat, 25 Feb 2012 15:34:13 GMT ChrisKarstens 2012-02-25T15:34:13Z Issue with SQL Expression using &quot;in_memory&quot; dataset https://community.esri.com/t5/python-questions/issue-with-sql-expression-using-amp-quot-in-memory/m-p/358715#M28313 <HTML><HEAD></HEAD><BODY><SPAN>I am trying to perform an SQL expression within the MakeFeatureLayer_management tool on a dataset stored in the "in_memory" workspace, like this...</SPAN><BR /><BR /><SPAN>arcpy.MakeFeatureLayer_management("in_memory\\resourceOL", "in_memory\\resourceOL_layer", "\"landuse\" = 0")</SPAN><BR /><BR /><SPAN>But this isn't working.&nbsp; I've also tried '"landuse" = 0', which didn't work either.&nbsp; However, when I run the "Make Feature Layer" tool from the System Toolboxes, it works fine.&nbsp; My current work around is to use arcpy.UpdateCursor() to delete rows where values in landuse != 0.</SPAN><BR /><BR /><SPAN>So, my questions are:</SPAN><BR /><BR /><SPAN>a) Am I doing something obviously wrong (e.g., syntax)?</SPAN><BR /><BR /><SPAN>b) If not, has anyone else experienced this?</SPAN><BR /><BR /><SPAN>c) If so, is this a bug within the arcpy module?&nbsp; </SPAN><BR /><BR /><SPAN>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).</SPAN><BR /><BR /><SPAN>Thank you,</SPAN><BR /><BR /><SPAN>Chris Karstens</SPAN></BODY></HTML> Sat, 25 Feb 2012 15:34:13 GMT https://community.esri.com/t5/python-questions/issue-with-sql-expression-using-amp-quot-in-memory/m-p/358715#M28313 ChrisKarstens 2012-02-25T15:34:13Z Re: Issue with SQL Expression using "in_memory" dataset https://community.esri.com/t5/python-questions/issue-with-sql-expression-using-amp-quot-in-memory/m-p/358716#M28314 <HTML><HEAD></HEAD><BODY><SPAN>the second argument of arcpy.MakeFeatureLayer_management is the name of the layer, not the "location".</SPAN><BR /><BR /><SPAN>change your code in arcpy.MakeFeatureLayer_management("in_memory\\resourceOL", "resourceOL_layer", "\"landuse\" = 0")</SPAN><BR /><BR /><SPAN>should work.</SPAN><BR /><BR /><SPAN>ciao,</SPAN><BR /><SPAN>AC</SPAN></BODY></HTML> Mon, 27 Feb 2012 07:25:39 GMT https://community.esri.com/t5/python-questions/issue-with-sql-expression-using-amp-quot-in-memory/m-p/358716#M28314 AlessandroCinnirella 2012-02-27T07:25:39Z