Bogue
An error occurs while using 'sde.next_rowid' to insert a row into a table using Python.
| Numéro d’ID de bogue | BUG-000094187 |
|---|---|
| Envoi | February 13, 2016 |
| Dernière modification | June 5, 2024 |
| S’applique à | ArcSDE/Enterprise Geodatabase |
| Version trouvée | 10.3 |
| Système d’exploitation | Windows OS |
| Version du système d’exploitation | 7.0 64 Bit |
| Statut | Non-Reproducible |
Informations supplémentaires
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)Étapes pour reproduire
ID de bogue: BUG-000094187
Logiciel:
- ArcSDE/Enterprise Geodatabase
Recevoir une notification lorsque le statut d’un bogue change
En savoir plus sur ce sujet
Rechercher des informations associées
Rechercher une formation sur ce sujet
Explorer des pistes et donner un avis
Obtenir de l’aide auprès des experts ArcGIS
Télécharger l’application Esri Support