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: 255

Filed under:

arcobjects

|

duplicate

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

ArcObjects - enumerating feature classes and datasets within a geodatabase

as seen on Stack Overflow - Search for 'Stack Overflow'
I'm trying to enumerate the contents (feature classes and feature datasets, not interested in tables, etc) of a file geodatabase using vba/arcobjects. I have the file GDB set as an IGxDatabase object, but can't find a way of getting further in. I've had a look at the geodatabase object model and… >>> More
How to Convert ILayer to IPolygon In ArcObjects

as seen on Stack Overflow - Search for 'Stack Overflow'
Having trouble converting an Ilayer to an IPolygon. I am developing a toolbar for ArcMap and I grab a layer via code from the side table of contents. The Layer is a Polygon, but the code won't convert it to a IPolygon. Can anyone help me out? This is the code I am using to try and convert it to… >>> More
F# and ArcObjects, Part 2

as seen on Geeks with Blogs - Search for 'Geeks with Blogs'
After accessing one feature now iterating through all features of a feature class: open System;; #I "C:\Program Files\ArcGIS\DotNet";; #r "ESRI.ArcGIS.System.dll";; #r "ESRI.ArcGIS.DataSourcesGDB.dll";; #r "ESRI.ArcGIS.Geodatabase.dll";; open ESRI.ArcGIS.esriSystem;; open ESRI.ArcGIS.DataSourcesGDB;; open… >>> More
F# and ArcObjects, Part 3

as seen on Geeks with Blogs - Search for 'Geeks with Blogs'
Today i played a little bit with IFeature-sequences and piping data. The result was a calculator of the bounding box around all features in a feature class. Maybe a little bit dirty, but for learning was it OK. ;-) open System;; #I "C:\Program Files\ArcGIS\DotNet";; #r "ESRI.ArcGIS.System… >>> More
F# and ArcObjects

as seen on Geeks with Blogs - Search for 'Geeks with Blogs'
After having a first look on F# its time to ask: Who could i use F# with ArcObjects. So my first steps was to do something with a feature in a F# interactive session. And these are my first code lines: open ESRI.ArcGIS.esriSystem;;open ESRI.ArcGIS.DataSourcesGDB;;open ESRI.ArcGIS.Geodatabase;;let… >>> More

Related posts about duplicate

Determine duplicate record for duplicate and non-duplicate records

as seen on Stack Overflow - Search for 'Stack Overflow'
I have a files containing both duplicate and non-duplicate records. The file is already sorted by a key. I want to determine those records that are duplicate and records that are non-duplicate. If duplicate the record is moved to a duplicate file and if non-duplicate that will be moved to valid… >>> More
AbstractMethodError on org.apache.xalan.processor.TransformerFactoryImpl

as seen on Stack Overflow - Search for 'Stack Overflow'
With the following code: private Document transformDoc(Source source) throws TransformerException, IOException { Transformer xslTransformer = TransformerFactory.newInstance().newTransformer(new StreamSource(pdfTransformXslt.getInputStream())); xslTransformer.setParameter("http://apache… >>> More
Yum Update Failing mod_ssl and glibc_devel

as seen on Server Fault - Search for 'Server Fault'
Any ideas on how to get this to not fail? # yum update Freeing read locks for locker 0x82: 4189/140342084876032 Freeing read locks for locker 0x84: 4189/140342084876032 Freeing read locks for locker 0x85: 4189/140342084876032 Freeing read locks for locker 0x86: 4189/140342084876032 Freeing read locks… >>> More
Will duplicate addEventListener calls create duplicate listener entries?

as seen on Stack Overflow - Search for 'Stack Overflow'
If I have an object that calls addEventListener(Event.ENTER_FRAME, update); addEventListener(Event.ENTER_FRAME, update); will that add 2 listeners? >>> More
YUM Update Failed - Error in POSTIN scriptlet in rpm package

as seen on Server Fault - Search for 'Server Fault'
Running "yum update" and it gets to installing and then breaks. Not sure what the problem is. Google shows nothing. Error in POSTIN scriptlet in rpm package gtk2-2.18.9-10.el6.x86_64 error: error creating temporary file /var/tmp/rpm-tmp.NB84HC: Invalid argument error: Couldn't create temporary file… >>> More