topic Re: SearchCursor sql_clause not working in Python Questions

SearchCursor sql_clause not working

mmann1123 — Wed, 14 Sep 2022 13:29:37 GMT

I am working with searchcursors for a .shp file with arcpy 3.0-py39. I am unable to get the searchcursor's sql clause to do frankly anything. Regardless of my clause I get the same result (all rows printed to screen, unordered).

For instance both of these provide the same response:

for row in arcpy.da.SearchCursor(in_table="Crashes_in_DC", field_names="Tot_PedBik", sql_clause=('TOP 3', None)): print(f" {row[0]}" )

for row in arcpy.da.SearchCursor(in_table="Crashes_in_DC", field_names="Tot_PedBik", sql_clause=(None, 'ORDER BY Tot_PedBik DESC')): print(f" {row[0]}" )

Re: SearchCursor sql_clause not working

dgiersz_cuyahoga — Wed, 14 Sep 2022 13:47:27 GMT

I don't think you can use either of those SQL queries against a shapefile (see Example 5a & 6): https://pro.arcgis.com/en/pro-app/latest/arcpy/data-access/searchcursor-class.htm

May have better luck using the where_clause with shapefiles.

Re: SearchCursor sql_clause not working

mmann1123 — Wed, 14 Sep 2022 13:49:03 GMT

Ok I will try that.

Re: SearchCursor sql_clause not working

mmann1123 — Wed, 14 Sep 2022 13:54:34 GMT

They could at least throw a warning my way though...