topic Re: Select features from a Feature Class in ArcObjects SDK Questions

Select features from a Feature Class

ShaningYu — Fri, 11 Oct 2013 14:27:10 GMT

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.

Re: Select features from a Feature Class

JeffMatson — Fri, 11 Oct 2013 15:39:32 GMT

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.

Re: Select features from a Feature Class

ShaningYu — Fri, 11 Oct 2013 16:30:51 GMT

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

Re: Select features from a Feature Class

LeoDonahue — Fri, 11 Oct 2013 22:05:05 GMT

Way to go Jeff Matson!!

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