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.

And ONE MORE idea

I remember once somebody have mention similar problem because
    was HIDDEN symbols

If you do COPY PASTE of this word 'Concert' from some other app
Or file, may happens it contains inside invisible chars.

If you TYPE it you get in fact OTHER word.



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