Invalid SQL syntax: SQLSTATE=42601

CliveSwan — Thu, 25 Feb 2021 15:54:53 GMT

Greetings,

I am trying to use arcpy.da.SearchCursor to return a row, and get the extent (min, max).

I used the ESRI example: Use SQL TOP to limit the number of records to return.

# Use SQL TOP to sort field values for row in arcpy.da.SearchCursor(fc, fields, sql_clause=('TOP 3', None)):

My code: gets an error at 'for row in arcpy.da...'

RuntimeError: Invalid SQL syntax [ERROR: syntax error at or near "3"??

Appreciate any pointers,

Regards,

Clive

for dirpath, dirnames, filenames in arcpy.da.Walk(workspace, topdown=True, datatype=data_type): #datasets = [''] + datasets if datasets is not None else [] for filename in filenames: #print(filename) ### Prints the path + name fc_name = filename.split('.')[-1] print(fc_name) sc = arcpy.da.SearchCursor(r"D:\Users\me\db.sde\fc",["polygon"]) for row in sorted(arcpy.da.SearchCursor(sc, ["Shape@"], sql_clause=('TOP 1', None)): print(row)

I get an error @

Re: Invalid SQL syntax: SQLSTATE=42601

DavinWalker2 — Fri, 26 Feb 2021 05:51:51 GMT

Hi Clive,

Is your database and SQL Server or MS Access database? TOP is only supported by SQL Server and MS Access databases.

Re: Invalid SQL syntax: SQLSTATE=42601

VinceAngelo — Sat, 27 Feb 2021 01:24:36 GMT

Good call. The intertubes says the "SQLSTATE=42601" error is associated with IBM DB2.

- V

topic Re: Invalid SQL syntax: SQLSTATE=42601 in Geodatabase Questions

Invalid SQL syntax: SQLSTATE=42601

Re: Invalid SQL syntax: SQLSTATE=42601

Re: Invalid SQL syntax: SQLSTATE=42601