Bogue
Query with LIKE operator returns an error, "Invalid SQL statement was used" on a joined feature class.
| Numéro d’ID de bogue | BUG-000085345 |
|---|---|
| Envoi | February 17, 2015 |
| Dernière modification | January 28, 2021 |
| S’applique à | ArcSDE/Enterprise Geodatabase |
| Version trouvée | 10.1 |
| Statut | Will Not Be Addressed |
Informations supplémentaires
This is expected behavior. The LIKE operator is an operator for character strings. If it is used against a numeric field, the data must be converted to a string. Some databases support implicit conversion from numeric to text, some do not. If the data is pulled from a single database, the query validation can be pushed down to the database. In the case of data being pulled from multiple sources, the validation cannot be pushed to the database and client rules are used instead, and character string operators such as LIKE are flagged as invalid by client-side validation. To query character matches like this the data should be stored as text, or the query should be written using >= and <= operators.Étapes pour reproduire
ID de bogue: BUG-000085345
Logiciel:
- ArcSDE/Enterprise Geodatabase
Obtenir de l’aide auprès des experts ArcGIS
Télécharger l’application Esri Support
En savoir plus sur ce sujet
Rechercher des informations associées
Rechercher une formation sur ce sujet
Explorer des pistes et donner un avis