laptop and a wrench

漏洞

Unable to create a SQL UNION view from a feature class and a simple table. As a result, the error message, "Table not registered (-220). Unable to create view..." displays.

上次发布: August 25, 2014 No Product Found
漏洞 ID 编号 NIM014018
已提交December 29, 2007
上次修改时间April 28, 2025
适用范围No Product Found
找到的版本9.2
状态Will Not Be Addressed

附加信息

We apologize that we were unable to address this issue within the current product support cycle. If the issue continues to affect your work in a supported release, please contact Technical Support.

解决办法

Create SQL UNION view without geometry column if not needed, otherwise follow the steps below.1. Create a UNION view without geometry column. See example below.sdetable -o create_view -T UAView -t viewfc,viewtab -c "viewfc.OBJECTID,viewfc.fcname,<a href="http://viewtab.name" target="_blank">viewtab.name</a>" -w "viewfc.joinid = viewtab.joinid union select viewfc.OBJECTID,viewfc.fcname,TO_CHAR(NULL) NAME from viewfc where viewfc.joinid not in (select viewtab.joinid from viewtab)"2. Create a Spatial View based on previous Union View from Step 1. See example below.sdetable -o create_view -T UASView -t viewfc,uaview -c "viewfc.OBJECTID,viewfc.SHAPE,uaview.fcname,<a href="http://uaview.name" target="_blank">uaview.name</a>" -w "viewfc.objectid = uaview.objectid"

重现步骤

漏洞 ID: NIM014018

软件:

  • No Product Found

当漏洞状态发生变化时获得通知

下载 Esri 支持应用程序

发现关于本主题的更多内容

获取来自 ArcGIS 专家的帮助

联系技术支持部门

下载 Esri 支持应用程序

转至下载选项