I am trying to use
arcpy.da.InsertCursor() to insert rows to an SDE table but no rows were added and without any error message. I tried the same code with an exact replica table in a local FGDB and it worked fine. The code is simple:
workspace = r"Database Connections\SDE.sde" arcpy.env.workspace = workspace arcpy.env.overwriteOutput = True edit = arcpy.da.Editor(workspace) edit.startEditing(False, True) edit.startOperation() cursor = arcpy.da.InsertCursor(sde_table, ["Date_"]) cursor.insertRow(["10/21/2020"])
I also tried to use
arcpy.InsertCursor() and it works well in both SDE and local FGDB. Is there anything missing for getting
arcpy.da.InsertCursor() to work in SDE?
RDBMS: SQL Server 2012