locating field duplicates

[Ruslan Zasukhin]

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

> But, the field always was a unique field!
> 
> Then upon updating that field it created duplicates, (which should have
> failed).

Hmm, 

Then this sounds only as bad index.
Try reindex database.

This should fix it.
Please check that AFTER reindex, if you assign wrong value you get error
code in return.

> (Next in order to find what field was giving the unique field error I
> tried reindexing each table. When I found the table I turned off the
> Unique flag on one of the two unique fields. The error stopped. When
> trying to set the field to Unique again in VApp it looks like it fails
> to set, BUT it actually does set the field to unique, becoming visible
> when restarting VApp.)

Yes, this is CORRECT.

IF a field, already has not unique values,
But you ask mark such field as unique, Valentina try build UNIQUE index,
And of course fails. Valentina is not able resolve self what values must be
deleted or changed. This should do human



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