selecting row among duplicated ones in VBA

Posted by Elaine Kuo on Stack Overflow See other posts from Stack Overflow or by Elaine Kuo
Published on 2010-05-25T03:41:27Z Indexed on 2010/05/25 3:51 UTC
Read the original article Hit count: 285

Filed under:
|

ArcGIS 9.3 Arcobject

I wanna select one row of each duplicated SIDs in a field below. (an attribute table of a shape file)

The priority is R > S = I > 0
Therefore, among SID 87, FID1 will be selected.
(SID 88, STATUS will be S+I)
(SID 89, FID 6 will be chosen)

Please kindly advise VBA cord to run the selection and thanks.

FID    SID    STATUS 
 1     87       R
 2     87       O
 3     88       I
 4     88       S
 5     89       I
 6     89       R      
 7     89       I
 8     89       S

© Stack Overflow or respective owner

Related posts about arcobjects

Related posts about duplicate