Diagnose problem

[Richard McCoy]

The words themselves should be clean. I removed the uniqueness and now 
everything works correctly. I can find the words okay. Except I can't 
reapply uniqueness. If I try to make the field unique using SQL it simply 
ignores my command.

The problem only appears to affect words that begin with uppercase letters.

I did add the command:

Db.setCollationAttribute(#kStrenght,#kPrimary)

to have the database ignore case sensitivity. This has worked well, but 
seems like I didn't notice the problem until afterwards.

Thanks.


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


> On 8/7/09 11:01 PM, "Richard McCoy" <mcrmedia1 at insightbb.com> wrote:
>
>> Okay, I've gone into Valentina Studio 4 and used the query:
>>
>> select * from Kwrd_List where KwrdName = 'Concert'
>>
>> and get no results. But the word "Concert" is record 2148 and is clearly
>> visible in the table. Using the following query I can get all words 
>> beginning
>> with "C", including "Concert":
>>
>> select KwrdName from Kwrd_List where substring (upper(KwrdName) from 1 
>> for 1 =
>> 'C'
>>
>> I can add the word "Concert" to the table as record 2187. Now I have the 
>> word
>> "Concert" in the table as record 2148 AND 2187, even though the field is 
>> set
>> to Unique and should not allow redundancies.
>>
>> Do I simply have a corrupt table? What gives? Reindexing does nothing. 
>> Any
>> work arounds? I can't rebuild the table from scratch because other 
>> records are
>> dependent on the table RecIDs. Any suggestion would be appreciated.
>
> Can it be CASE problem?
>
> Have you change db.LocaleAttributes ?
>
>
> -- 
> 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