https://community.esri.com/t5/arcobjects-sdk-questions/vb-net-whereclause-table-field/m-p/1019086#M20245 <P>&nbsp;</P><P>Hi</P><P>how can I get data from table/Field&nbsp; = EXTRA.House&nbsp; &nbsp;/ number</P><P>&nbsp;</P><P>&nbsp;</P><LI-CODE lang="markup"> Public Sub search_address() Dim pMap As IMap Dim pMxDoc As IMxDocument Dim pFeatLayer As IFeatureLayer Dim pFeatSel As IFeatureSelection Dim pQueryFilter As IQueryFilter pMxDoc = CType(My.ArcMap.Application.Document, IMxDocument) pMap = pMxDoc.FocusMap Dim sLayerName As String sLayerName = Layer_address Dim i As Integer For i = 0 To pMap.LayerCount - 1 If pMap.Layer(i).Name = sLayerName Then pFeatLayer = pMap.Layer(i) Exit For End If Next i If pFeatLayer Is Nothing Then MsgBox(Layer_address &amp; " Error") Exit Sub End If pQueryFilter = New QueryFilter pQueryFilter.WhereClause = "HEI1 in (select HEI1 from EXTRA.House where number = 2502163)" Dim pFeaCursor As IFeatureCursor = pFeatLayer.Search(pQueryFilter, False) Dim pFeature As IFeature = pFeaCursor.NextFeature Do Until pFeature Is Nothing Dim index As Integer = pFeature.Fields.FindField("STREETNAMECODE") 'O(n) Dim sName As String = pFeature.Value(index) Dim newItem As New ListViewItem(pFeature.OID) If IsDBNull(pFeature.Value(pFeature.Fields.FindField("POSTALCODE"))) = False Then newItem.SubItems.Add(pFeature.Value(pFeature.Fields.FindField("POSTALCODE"))) Else newItem.SubItems.Add("") End If If IsDBNull(pFeature.Value(pFeature.Fields.FindField("STREETNAME"))) = False Then newItem.SubItems.Add(pFeature.Value(pFeature.Fields.FindField("STREETNAME"))) Else newItem.SubItems.Add("") End If Listv_search.Items.Add(newItem) pFeature = pFeaCursor.NextFeature Loop</LI-CODE><P>&nbsp;</P> Fri, 22 Jan 2021 13:47:59 GMT SigurdurGesr 2021-01-22T13:47:59Z https://community.esri.com/t5/arcobjects-sdk-questions/vb-net-whereclause-table-field/m-p/1019086#M20245 <P>&nbsp;</P><P>Hi</P><P>how can I get data from table/Field&nbsp; = EXTRA.House&nbsp; &nbsp;/ number</P><P>&nbsp;</P><P>&nbsp;</P><LI-CODE lang="markup"> Public Sub search_address() Dim pMap As IMap Dim pMxDoc As IMxDocument Dim pFeatLayer As IFeatureLayer Dim pFeatSel As IFeatureSelection Dim pQueryFilter As IQueryFilter pMxDoc = CType(My.ArcMap.Application.Document, IMxDocument) pMap = pMxDoc.FocusMap Dim sLayerName As String sLayerName = Layer_address Dim i As Integer For i = 0 To pMap.LayerCount - 1 If pMap.Layer(i).Name = sLayerName Then pFeatLayer = pMap.Layer(i) Exit For End If Next i If pFeatLayer Is Nothing Then MsgBox(Layer_address &amp; " Error") Exit Sub End If pQueryFilter = New QueryFilter pQueryFilter.WhereClause = "HEI1 in (select HEI1 from EXTRA.House where number = 2502163)" Dim pFeaCursor As IFeatureCursor = pFeatLayer.Search(pQueryFilter, False) Dim pFeature As IFeature = pFeaCursor.NextFeature Do Until pFeature Is Nothing Dim index As Integer = pFeature.Fields.FindField("STREETNAMECODE") 'O(n) Dim sName As String = pFeature.Value(index) Dim newItem As New ListViewItem(pFeature.OID) If IsDBNull(pFeature.Value(pFeature.Fields.FindField("POSTALCODE"))) = False Then newItem.SubItems.Add(pFeature.Value(pFeature.Fields.FindField("POSTALCODE"))) Else newItem.SubItems.Add("") End If If IsDBNull(pFeature.Value(pFeature.Fields.FindField("STREETNAME"))) = False Then newItem.SubItems.Add(pFeature.Value(pFeature.Fields.FindField("STREETNAME"))) Else newItem.SubItems.Add("") End If Listv_search.Items.Add(newItem) pFeature = pFeaCursor.NextFeature Loop</LI-CODE><P>&nbsp;</P> Fri, 22 Jan 2021 13:47:59 GMT https://community.esri.com/t5/arcobjects-sdk-questions/vb-net-whereclause-table-field/m-p/1019086#M20245 SigurdurGesr 2021-01-22T13:47:59Z https://community.esri.com/t5/arcobjects-sdk-questions/vb-net-whereclause-table-field/m-p/1019180#M20246 <P>Hi,</P><P>Here is your problem:</P><LI-CODE lang="markup"> pQueryFilter.WhereClause = "HEI1 in (select HEI1 from EXTRA.House where number = 2502163)"</LI-CODE><P>You need to add to WhereClause only where section of your query:</P><LI-CODE lang="markup"> pQueryFilter.WhereClause = "number = 2502163"</LI-CODE> Fri, 22 Jan 2021 17:25:44 GMT https://community.esri.com/t5/arcobjects-sdk-questions/vb-net-whereclause-table-field/m-p/1019180#M20246 GKmieliauskas 2021-01-22T17:25:44Z https://community.esri.com/t5/arcobjects-sdk-questions/vb-net-whereclause-table-field/m-p/1019278#M20247 <P>&nbsp;</P><P>I can get record from pFeatLayer but I can not get record from EXTRA.House</P><LI-CODE lang="markup">pQueryFilter.WhereClause = "HEI1 in (select HEI1 from EXTRA.House where number = 2502163)" </LI-CODE><P>&nbsp;</P> Fri, 22 Jan 2021 21:09:41 GMT https://community.esri.com/t5/arcobjects-sdk-questions/vb-net-whereclause-table-field/m-p/1019278#M20247 SigurdurGesr 2021-01-22T21:09:41Z https://community.esri.com/t5/arcobjects-sdk-questions/vb-net-whereclause-table-field/m-p/1019301#M20248 <P>What is your backend data source, RDBMS, FGDB, etc...?&nbsp; I assume you are getting an error, what exactly is the error message?</P> Fri, 22 Jan 2021 22:03:23 GMT https://community.esri.com/t5/arcobjects-sdk-questions/vb-net-whereclause-table-field/m-p/1019301#M20248 JoshuaBixby 2021-01-22T22:03:23Z