laptop and a wrench

Bogue

SQL expressions fail for the Make Feature Layer tool when a join is present.

Dernière publication: April 19, 2017 ArcGIS for Desktop
Numéro d’ID de bogue NIM066754
EnvoiMarch 31, 2011
Dernière modificationJune 5, 2024
S’applique àArcGIS for Desktop
Version trouvée10.0
StatutNon-Reproducible

Informations supplémentaires

This issue is not reproducible in ArcGIS 10.4.1.

Solution de contournement

- Use the Select by Attributes tool before running the Make Feature Layer tool. - Create a definition query after the join, but before running the Make Feature Layer tool. ----- Let Feature Class A = The feature class to which the table is joined. Let Table B = The feature class which is joined to Feature Class A. 1. Establish which joined field (Field B) from Table B forms the basis for the query within the Make Feature Layer tool. 2. Before the join, create a field (Field A) in Feature Class A which is the equivalent to the desired field from Table B. 3. Join Table B to Feature Class A. 4. Set Field A = Field B. 5. Open the Make Feature Layer tool and create the SQL query based on Field A instead of Field B.

Étapes pour reproduire

ID de bogue: NIM066754

Logiciel:

  • ArcGIS for Desktop

Recevoir une notification lorsque le statut d’un bogue change

Télécharger l’application Esri Support

En savoir plus sur ce sujet

Obtenir de l’aide auprès des experts ArcGIS

Contacter le support technique

Télécharger l’application Esri Support

Accéder aux options de téléchargement