UE

[Richard McCoy]

Wow. Thanks for that. Turns out I have 12 duplicate words. Each duplicate is 
entered with its own RecID with either upper or lower case. For instance:

114        gate
2134      Gate

This means that a user can enter the word either way and the table doesn't 
recognize it as unique. What's my best bet to have Valentina catch this, or 
should I check first in lingo and update accordingly?



----- Original Message ----- 
From: "Ruslan Zasukhin" <ruslan_zasukhin at valentina-db.com>
To: <valentina at lists.macserve.net>
Sent: Friday, August 07, 2009 4:37 PM
Subject: UE


> On 8/7/09 11:26 PM, "Richard McCoy" <mcrmedia1 at insightbb.com> wrote:
>
>> One other thing, just noticed. I can unselect "Unique" and "Index"  in
>> studio and it appears to solve the problem. The diagnose comes back 
>> clean.
>
> Yes because now index file do not exists.
> So it not complains
>
>> However, when I try to check the "Unique" setting again I get the error
>> message attached. Any way to resolve this?
>
> It looks that now during indexing it SEE at least one duplicate.
>
> May be this is that second CONCERT word,
> Which you have add ?
>
> You can try find duplicate building using just INDEXED,
> Then do
>
> SELECT fldKeyWord, COUNT(fldKeyWord) as c
> FROM T
> GROUP BY fldKeyWord
> HAVING c >= 2
>
> This query as you can see should find words, that present 2 or more times 
> in
> the table
>
> Then you should correct these records
> And try set index to be UNIQUE
>
>
>
> -- 
> Best regards,
>
> Ruslan Zasukhin
> VP Engineering and New Technology
> Paradigma Software, Inc
>
> Valentina - Joining Worlds of Information
> http://www.paradigmasoft.com
>
> [I feel the need: the need for speed]
>
>
> _______________________________________________
> Valentina mailing list
> Valentina at lists.macserve.net
> http://lists.macserve.net/mailman/listinfo/valentina