search

MarkMpn / Sql4Cds

SQL 4 CDS core engine and XrmToolbox tool
MIT License
74 stars 22 forks source link

Object reference not found error #474

Closed sybaris closed 2 months ago

sybaris commented 3 months ago

Hi,

When I try to run this query 

select top 10 W2.name  from webresource W2
where NOT EXISTS (
 select TOP 10 W.webresourceid
 from webresource W
 inner join solutioncomponent SC on SC.objectid=W.webresourceid
 where W.webresourceid=W2.webresourceid
)

I have the following error : Object reference not set to an instance of an object

image

Regards Sybaris PS : I use the version 9.0.1