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, 2014No 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"