[Gvsig_english] Find duplicates

[Antonio Falciano]

Hi Wolfgang,
the answer to your question is naturally yes.
The idea would be to perform two select statement on the table:
- a first, simply to make a record count;
- the second, a 'select distinct', to know the number of unique value
assumed by the field of your interest.
Then, make the difference between the two values previously calculated
and so if this is zero the table is ok, else we have to check the table
...and so on.
It would be great if it's possible to create something like
http://arcscripts.esri.com/scripts.asp i.e. a repository where
developers and users can upload/download their scripts so improving
gvSIG functionalities and solving most common users' problems.

Best regards,
Antonio

Wolfgang Qual ha scritto:
> Hi list,
> I remember ArcView 3.2 having an extension to look for duplicates in an 
> attribute table. This can be handy, if you would like to make sure that you 
> have a unique-value-column (which should be later used as the ID-column for a 
> join, etc.). Question therefore: is it already possible in gvSIG to perform 
> such a search or: do developers think of something like this? Could be really 
> handy ;)
> 
> Greetings,
> Wolfgang
> _______________________________________________
> Gvsig_internacional mailing list
> Gvsig_internacional at runas.cap.gva.es
> http://runas.cap.gva.es/mailman/listinfo/gvsig_internacional
> 
>