NIM014018 for No Product Found

Bug-ID-Nummer	NIM014018
Eingereicht	December 29, 2007
Zuletzt geändert	April 28, 2025
Gilt für	No Product Found
Gefunden in Version	9.2
Status	Will Not Be Addressed

Zusätzliche Informationen

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.

Workaround

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"