PROBLEM

A table window with empty rows appears when opening a table from a layer or table based on a query

Last Published: April 25, 2020

Description

A feature layer or table can successfully be generated based on a query for an OLE DB connection. However, only blank rows appear when opening the table window.

Cause

Some OLE DB providers require qualification to be consistent in a query. If the query is fully qualified in one area, it must be fully qualified in all other areas. For example, the following statement fully qualifies in the where clause and when indicating the key column, but not the select clause:

Select field1
from table1
where table1.field1 > 1
Primary Key = table1.field1

The statement above will work properly for some providers, but not for others.

Solution or Workaround



Be consistent with qualification throughout the query. If the query performs a join, fully qualify table and column names.

If a * is used in the select clause, the fields are interpreted as fully qualified if the query performs a join. Otherwise, they are interpreted as unqualified.

Article ID:000005734

Software:
  • ArcMap

Receive notifications and find solutions for new or common issues

Get summarized answers and video solutions from our new AI chatbot.

Download the Esri Support App

Discover more on this topic

Get help from ArcGIS experts

Contact technical support

Download the Esri Support App

Go to download options