English

Problem: Query on an ArcSDE for Coverages layer fails to return records

Description

A query on an ArcSDE for Coverages layer fails to return records when using the MapObjects FilterExpression property or the SearchExpression method.

Cause

The query syntax may be invalid for ArcSDE for Coverages. ArcSDE for Coverages requires INFO operators rather than SQL expressions.

Solution or Workaround

Use INFO operators, such as cn or lk, in your queries.

Sample FilterExpression:

lyr.FilterExpression = "CityName cn 'New'"

Sample SearchExpression:

Set recs = lyr.SearchExpression("st_name lk 'Dakota'")

Refer to the workstation ArcInfo or ArcSDE for Coverages documentation for additional information.