Diagnose problem

[Ruslan Zasukhin]

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]