queryFilter Count

DaveCouture — Sun, 12 Dec 2021 15:57:15 GMT

I'm trying to add a count to a Query, so I can pop a message if the count = 0 (didn't find the record). This is what I have:

Public Sub SelectMapFeaturesByAttributeQuery(ByVal activeView As IActiveView, ByVal featureLayer As IFeatureLayer, ByVal whereClause As System.String)

        If activeView Is Nothing OrElse featureLayer Is Nothing OrElse whereClause Is Nothing Then
            Return
        End If

        Dim featureSelection As IFeatureSelection = TryCast(featureLayer, IFeatureSelection) ' Dynamic Cast

        ' Set up the query
        Dim queryFilter As IQueryFilter = New QueryFilterClass
        queryFilter.WhereClause = whereClause

        ' Invalidate only the selection cache. Flag the original selection
        activeView.PartialRefresh(esriViewDrawPhase.esriViewGeoSelection, Nothing, Nothing)

        ' Perform the selection
        featureSelection.SelectFeatures(queryFilter, esriSelectionResultEnum.esriSelectionResultNew, False)

       
        ' Perform query count
        Dim value As Integer = 0
        value = featureLayer.GetFeatureCount(queryFilter)

        If value = 0 Then
            MsgBox("can't find PID")
        End If


        ' Flag the new selection
        activeView.PartialRefresh(esriViewDrawPhase.esriViewGeoSelection, Nothing, Nothing)


    End Sub

Re: queryFilter Count

KenBuja — Tue, 19 Jun 2012 13:01:23 GMT

Since you've already queried the feature layer to get the feature selection, why not use that instead of querying the feature layer again?

   If featureSelection.SelectionSet.Count() = 0 Then      MsgBox("can't find PID")    End If

Re: queryFilter Count

DaveCouture — Tue, 19 Jun 2012 13:08:36 GMT

Thanks again, Ken!

topic queryFilter Count in ArcObjects SDK Questions

queryFilter Count

Re: queryFilter Count

Re: queryFilter Count