laptop and a wrench

Bug

Great Queries by Select By Attributes doesn't work with ORACLE data, but works with fGDB and SQL Server.

Zuletzt veröffentlicht: August 25, 2014 No Product Found
Bug-ID-Nummer NIM031527
EingereichtJanuary 23, 2008
Zuletzt geändertApril 28, 2025
Gilt fürNo Product Found
Gefunden in Version9.2
StatusKnown Limit

Zusätzliche Informationen

No Public Explanation

Workaround

Modify the where clause for your oracle case to use nested queries or joins...Joins would be the fastest - "or" and "in" clauses are normally much slower.Examples:select * from user.Parcels where (PARCEL_ID in (1...1000) orPARCEL_ID in (1001...2000) )=================(select ... from ... where PARCEL_ID in (1, 2, ... 1000) )UNION(select ... from ... where PARCEL_ID in (1001, 1002, ... 2000))...UNION(select ... from ... where PARCEL_ID in (N, N+1, ... M)=================You can use ArcObjects (IDatabaseConnectionInfo2.ConnectionDBMS Property) to determine the type of GDB connected to if needed.

Schritte zur Reproduzierung

Bug-ID: NIM031527

Software:

  • No Product Found

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