PROBLEM

Queries on shapefiles are not working in ArcIMS services

Last Published: April 25, 2020

Description

** Internal Publish Only! This article may contain information that is not intended for external circulation. **

While querying shapefiles in an ArcIMS Service there is an error message in the HTML Viewer's Query frame, ArcExplorer Java Editon or Java Viewer message console, or Spatial Server log files stating that an Invalid SQL where clause was entered.

Cause

The ArcIMS Spatial Server has a known limitation dealing with upper case field names in shapefiles.

Solution or Workaround

Check the validity of the expression by confirming that the query works on a local shapefile. If the expression works on a local shapefile, check the shapefile's DBF to ensure that all the DBF column names are upper case.

You must change the case of the DBF column name for the expression to work. Two relatively easy ways to do this are as follows:

  • Import the shapefile into ArcSDE, then export it back out to a new shapefile.
  • Convert the shapefile to a coverage (using shp2cov) and then convert it back to a shapefile.

Article ID:000003567

Software:
  • Legacy Products

Get help from ArcGIS experts

Contact technical support

Download the Esri Support App

Go to download options

Discover more on this topic

Esri Community

Search for related information

Training

Find training related to this topic

ArcGIS Ideas

Explore ideas and give feedback