I am trying to update some rows in a SQL Server database table (not registered with geodatabase) with arcpy.da.UpdateCursor. However, when running the
deleteRow(), I get the
error return without exception set error. Updating geodatabase tables works fine.
I guess it might be a limitation of arcpy which can't edit a non-registered with geodatabase RDBMS table (in this case, SQL Server), but I want to make sure I don't miss anything.
Can ArcSDESQLExecute class help me to update SQL Server table that are not registered in geodatabase (have found no info on that in the Help)? Any other workarounds?
I have ended up using ArcSDESQLExecute which works fine for executing SQL commands (including deleting rows) for tables that are not registered with geodatabase.
sde_conn = arcpy.ArcSDESQLExecute(r"C:\GIS\Temp\nongeo.sde") sql_statement = """delete from added_table WHERE AddID = 2 """