ERROR

An invalid SQL statement was used

Last Published: July 17, 2020

Error Message

In ArcMap, when attempting to display X and Y coordinate data in a table from a CSV file, the following error occurs:

Error:    
An invalid SQL statement was used.

Cause

This error occurs due to one of the following reasons:

  • Not exporting the X, Y event layer permanently after adding the X and Y coordinate data to the map.
  • Proper formatting rules are not adhered to when naming the X and Y coordinate fields.
  • The X and Y coordinate fields have text set as data type instead of numeric data type.

Solution or Workaround

There are three possible solutions for this issue, depending on the cause.

  • Make the X, Y event layer permanent by saving the X and Y coordinate data as a shapefile in a project folder, or as a feature class in a file geodatabase. When the X and Y coordinate data are added to the map, it becomes an X, Y event layer. In ArcMap, event layers are designed to be temporary, which means┬áthe event layers defined during a session do not persist after the session ends.
  • Comply with formatting conventions when naming the fields to ensure ArcMap recognizes the field names set in a table to display the X and Y coordinate data. Reserved words cannot be used as field names, and field names must start with a letter and can only contain letters, numbers and underscores without any spaces.
  • Convert the X and Y values to decimal degrees, and store the values as a numeric field because coordinate value is recognized as numeric data. Refer to ArcMap: Adding x, y coordinate data as a layer for more information.

Article ID:000012583

Software:
  • ArcMap

Get help from ArcGIS experts

Contact technical support

Download the Esri Support App

Go to download options

Related Information

Discover more on this topic