laptop and a wrench

Bug

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

Zuletzt veröffentlicht: April 19, 2017 ArcGIS for Desktop
Bug-ID-Nummer NIM066754
EingereichtMarch 31, 2011
Zuletzt geändertJune 5, 2024
Gilt fürArcGIS for Desktop
Gefunden in Version10.0
StatusNon-Reproducible

Zusätzliche Informationen

This issue is not reproducible in ArcGIS 10.4.1.

Workaround

- 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.

Schritte zur Reproduzierung

Bug-ID: NIM066754

Software:

  • ArcGIS for Desktop

Benachrichtigung erhalten, wenn sich der Status eines Bugs ändert

Esri Support App herunterladen

Weitere Informationen zu diesem Thema erkunden

Unterstützung durch ArcGIS-Experten anfordern

An den technischen Support wenden

Esri Support App herunterladen

Zu Download-Optionen wechseln