locating field duplicates

[Ruslan Zasukhin]

on 12/2/03 1:58 AM, Tim Davis at timdavis at amug.org wrote:

>>    Is there a way in VApp to search for field value duplicates? I have
>> a table in which a field is unique, but when indexing it fails due to
>> the field being unique. I'd rather modify the data than switch off the
>> unique property (even though it didn't stop this occurrence entirely).
> 
> More info...
> The records that became duplicates were modified (Updated) using SQL on
> the Server.
> Isn't the unique field property supposed to prevent creating duplicate
> field values?

Hi Tim,

Yes of course.
When you create field, you can specify flag UNIQUE.
You can also assign it in VAPP for a field.


IF you already have duplicates in Table and want clean up them,
Then you can to use viSQL and SQL commands as

    SELECT fld, COUNT(fld)
    FROM T
    GROUP BY fld


-- 
Best regards,
Ruslan Zasukhin      [ I feel the need...the need for speed ]
-------------------------------------------------------------
e-mail: ruslan at paradigmasoft.com
web: http://www.paradigmasoft.com

To subscribe to the Valentina mail list go to:
http://lists.macserve.net/mailman/listinfo/valentina
-------------------------------------------------------------