laptop and a wrench

Erro

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.

Última Publicação: August 25, 2014 No Product Found
Número de ID do Erro NIM014018
EnviadoDecember 29, 2007
Última ModificaçãoApril 28, 2025
Aplica-se àNo Product Found
Versão encontrada9.2
StatusWill Not Be Addressed

Informações Adicionais

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.

Solução Provisória

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"

Etapas para Reproduzir

ID do Erro: NIM014018

Software:

  • No Product Found

Seja notificado quando o status de um erro mudar

Baixe o Aplicativo de Suporte da Esri

Descubra mais sobre este tema

Obtenha ajuda de especialistas do ArcGIS

Entre em contato com Suporte Técnico

Baixe o Aplicativo de Suporte da Esri

Ir para as opções de download