nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Select features from a Feature Class

ShaningYu

For Feature Class in a GDB, I queried in Oracle SQL Developer:
select * from RailLRSRoutes where RouteName = 'A1'
and got 12 records returned. Got the same results using Definition Query in ArcMap.
In the piece of code below:
            IQueryFilter queryFilter = new QueryFilterClass();
            queryFilter.WhereClause = "RouteName = 'A1' ";
            IDataset dataset = (IDataset)fc;
            ISelectionSet pSelectionSet = fc.Select(queryFilter, esriSelectionType.esriSelectionTypeHybrid, esriSelectionOption.esriSelectionOptionOnlyOne, dataset.Workspace);
the pSelectionSet.Count = 1 rather than multiple. What's wrong with my code here? Thanks.

Find more posts tagged with

Accepted answers

JeffMatson

Try changing esriSelectionOption.esriSelectionOptionOnlyOne to esriSelectionOption.esriSelectionOptionNormal

For Feature Class in a GDB, I queried in Oracle SQL Developer:
select * from RailLRSRoutes where RouteName = 'A1'
and got 12 records returned. Got the same results using Definition Query in ArcMap.
In the piece of code below:
            IQueryFilter queryFilter = new QueryFilterClass();
            queryFilter.WhereClause = "RouteName = 'A1' ";
            IDataset dataset = (IDataset)fc;
            ISelectionSet pSelectionSet = fc.Select(queryFilter, esriSelectionType.esriSelectionTypeHybrid, esriSelectionOption.esriSelectionOptionOnlyOne, dataset.Workspace);
the pSelectionSet.Count = 1 rather than multiple. What's wrong with my code here? Thanks.

All comments

LeoDonahue

Way to go Jeff Matson!!

Eustace would sell those points for money to pay his taxes.

ShaningYu

jeffmatson: Wonderful. Problem fixed per your feedback. Thanks and have a nice weekend!

JeffMatson

Try changing esriSelectionOption.esriSelectionOptionOnlyOne to esriSelectionOption.esriSelectionOptionNormal

For Feature Class in a GDB, I queried in Oracle SQL Developer:
select * from RailLRSRoutes where RouteName = 'A1'
and got 12 records returned. Got the same results using Definition Query in ArcMap.
In the piece of code below:
            IQueryFilter queryFilter = new QueryFilterClass();
            queryFilter.WhereClause = "RouteName = 'A1' ";
            IDataset dataset = (IDataset)fc;
            ISelectionSet pSelectionSet = fc.Select(queryFilter, esriSelectionType.esriSelectionTypeHybrid, esriSelectionOption.esriSelectionOptionOnlyOne, dataset.Workspace);
the pSelectionSet.Count = 1 rather than multiple. What's wrong with my code here? Thanks.

Join the Conversation

Signed in members can post, follow updates, and more. New here? Register a free account.

Quick Links

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.