Bug
The UpdateCursor class in ArcPy returns the error message, "RuntimeError: An expected Field was not found or could not be retrieved properly" when the TOP prefix is used as a SQL Clause to return only a specified number of records for a feature class or table in a SQL geodatabase.
| Bug-ID-Nummer | BUG-000120309 |
|---|---|
| Eingereicht | February 25, 2019 |
| Zuletzt geändert | June 5, 2024 |
| Gilt für | ArcGIS Pro |
| Gefunden in Version | 2.3 |
| Betriebssystem | Windows OS |
| Betriebssystemversion | 10.0 64 Bit |
| Status | Non-Reproducible |
Zusätzliche Informationen
This issue is not reproducible in the latest version of the software. For inquiries or if the issue persists, contact Esri Technical Support.Workaround
The postfix 'ORDER BY' clause correctly functions which means the table list can be sorted in the returned result. After the list is sorted, use a while loop to iterate through and update each row a set number of times. For example, a while loop iterating up to 20 is used to only update the first 20 rows of the table that are already sorted. This simulates the same results as using the 'TOP 20' clause.
Schritte zur Reproduzierung
Bug-ID: BUG-000120309
Software:
- ArcGIS Pro
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