Bug
An error occurs while using 'sde.next_rowid' to insert a row into a table using Python.
| Bug-ID-Nummer | BUG-000094187 |
|---|---|
| Eingereicht | February 13, 2016 |
| Zuletzt geändert | June 5, 2024 |
| Gilt für | ArcSDE/Enterprise Geodatabase |
| Gefunden in Version | 10.3 |
| Betriebssystem | Windows OS |
| Betriebssystemversion | 7.0 64 Bit |
| Status | Non-Reproducible |
Zusätzliche Informationen
Next_RowID takes a table that is registered with the geodatabase as an input parameter and returns the next value for the ObjectID (RowID) field. You can use this value when you are inserting a row to the table using SQL. When executing through ArcGIS we pass the execution through the ODBC driver, and SQL Server will use sp_describe_first_result_set to return the metadata for the first possible result set of the Transact-SQL batch. Because of this behavior via the Microsoft ODBC client driver, you must include WITH RESULT SETS NONE into the execution of NEXT_ROWID. i.e. import arcpy sql="DECLARE @oid INT; DECLARE @owner nvarchar(128) = 'dbo'; DECLARE @table nvarchar(128) = 'TABTEST'; EXEC dbo.next_rowid @owner , @table, @oid OUTPUT WITH RESULT SETS NONE; INSERT INTO dbo.TABTEST(OBJECTID,NAME,C1) VALUES (@oid,'prvni',1);" con = arcpy.ArcSDESQLExecute(r'Database Connections\enterpriseGDB.sde') con.execute(sql)Schritte zur Reproduzierung
Bug-ID: BUG-000094187
Software:
- ArcSDE/Enterprise Geodatabase
Benachrichtigung erhalten, wenn sich der Status eines Bugs ändert
Weitere Informationen zu diesem Thema erkunden
Nach zugehörigen Informationen suchen
Nach Schulungen zu diesem Thema suchen
Ideen erkunden und Feedback geben
Unterstützung durch ArcGIS-Experten anfordern
Esri Support App herunterladen