NIM014018 for No Product Found

Numéro d’ID de bogue	NIM014018
Envoi	December 29, 2007
Dernière modification	April 28, 2025
S’applique à	No Product Found
Version trouvée	9.2
Statut	Will Not Be Addressed

Informations supplémentaires

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.

Solution de contournement

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"