Bogue
Features with null values are ignored or not displayed when using the '<>' (not equal) operator in ArcMap.
| Numéro d’ID de bogue | BUG-000104895 |
|---|---|
| Envoi | May 3, 2017 |
| Dernière modification | June 5, 2024 |
| S’applique à | ArcGIS for Desktop |
| Version trouvée | 10.5 |
| Statut | Known Limit |
Informations supplémentaires
I tested your case against the numeric "numb" field and a calculated text field "testnumb" and neither returns the null record. Detailed documentation on this can be found here: https://technet.microsoft.com/en-us/library/ms191270(v=sql.105).aspx. Essentially, NULL is not the same as blank, empty, or zero. It is an "unknown". Because it is of "unknown" value, our definition queries and selections will not return the value. To return the selection you desire, the correct query is: SELECT * FROM test1 WHERE numb <>1 OR numb IS NULL.Étapes pour reproduire
ID de bogue: BUG-000104895
Logiciel:
- ArcGIS for Desktop
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