Is This Content Helpful?
We're glad to know this article was helpful.
Opening an ADO recordset based on a join between two ArcSDE tables, using the ESRI OLE DB provider, fails with the following FDO error:
This will occur if the SQL statement used to open the record set includes the SHAPE.AREA or SHAPE.LEN columns. Although these columns are present when the data is previewed in ArcCatalog/ArcMap, these fields are maintained in a separate table and do not form part of the base tables.
Construct an SQL statement that does not include these columns when opening a recordset based on a join between two ArcSDE tables.