AnsweredAssumed Answered

What SQL commands do in_memory workspaces support?

Question asked by rcoodey on Sep 23, 2015
Latest reply on Sep 23, 2015 by vangelo-esristaff

In_memory workspaces are great to work with, especially when needing temporary/intermediate steps in an ArcPy script. Currently I am using an arcpy.da.SearchCursor against one and using simple where_clause statements with operators (>, <, =) seem to work just fine. But trying to take it a bit further and use a sql_clause to prefix with a 'DISTINCT' or postfix with a 'ORDER BY' and it doesn't seem to obey those.

 

Is there any documentation that says what SQL is supported by these in_memory workspaces?

 

Thanks a lot for any help and information!

Outcomes