Ceating a SELECT query in arcpy.da.SearchCursor

CliveSwan

If I SELECT ALL the query, without the select works.

I only want to loop through 5 - 10 records, not 30,000. So trying to get a select statement to limit the number of records returned.

This code works:

    for filename in filenames:
        try:
            for row in (arcpy.da.SearchCursor(filename, ['Shape@'])):               
                print(filename)

 

The sql_clause throws an error??

    for filename in filenames:
        try:
            for row in arcpy.da.SearchCursor(filename, ['OBJECTID@', 'Shape@'], sql_clause=('select * from ' + ['OBJECTID@', 'Shape@'] + 'limit 5', None)):
                print(filename)

 

Appreciate any pointers to fixing the sql_clause.

Thanks,

Clive

danretired

have you tried the where clause to limit the object ids queried?

whr = "OBJECTID >= 3 AND OBJECTID <= 9"   # -- limit to records 3 through 9

c = arcpy.da.SearchCursor(in_fc, ('OID@', 'SHAPE@'), whr, SR)

for i in c:
    print(c)
    
(3, <Polygon object at 0x228a22acd08[0x228a22d75a0]>)
(4, <Polygon object at 0x228a22ac208[0x228a22d7db0]>)
(5, <Polygon object at 0x228a22acd08[0x228a22d75a0]>)
(6, <Polygon object at 0x228a22ac208[0x228a22d7db0]>)
(7, <Polygon object at 0x228a22acd08[0x228a22d75a0]>)
(8, <Polygon object at 0x228a22ac208[0x228a22d7db0]>)