Diagnose problem

[Richard McCoy]

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.

Thanks.
  ----- Original Message ----- 
  From: Richard McCoy 
  To: Richard McCoy ; Valentina Developers 
  Sent: Friday, August 07, 2009 3:43 PM
  Subject: Re: Diagnose problem


  Since sending this post I've been testing and discovered that there is a problem. Some words are not recognized in the table with basic queries even though they are in the table. When adding the word again it is appended to the table with a new RecID even though it already exists and the table is set to UNIQUE. This absolutely should NEVER happen!

  Any idea why a unique field would allow redundant entries of a single word? If Valentina allows for redundancies such as this then my entire keyword indexing system falls apart.

  Thanks.
    ----- Original Message ----- 
    From: Richard McCoy 
    To: Valentina Developers 
    Sent: Friday, August 07, 2009 9:34 AM
    Subject: Diagnose problem


    Including the diagnose report for this table. This is a table with one field named "KwrdName" that is set to be Unique. Its purpose is to collect keywords entered into the system by users without redundancy. When I diagnose the entire database, everything comes back OK except this field (see attachment). 

    I've reindexed this field and the table and also cloned and reloaded the entire database. Nothing seems to work in resolving this reported discrepancy. 

    You'll notice from the provided JPGs that the record count is correct. No records have ever been deleted from this field. However, the error report indicates 74 missing records. The Index count differs from the field record count.

    Field: KwrdName. Index record count (2112) differ from field one (2186).
    Field: KwrdName. Index have 74 missing records.

    This doesn't appear to affect the database record retrieval in any way and I haven't noticed any problems. But is this something to be concerned about? If so, how can I correct the problem. Have no idea why the index should be reporting missing records when the record count for the field is entirely accurate.


    Thanks.

    Richard McCoy
    Executive Creative Director
    MCR Media Associates, LLC
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.macserve.net/pipermail/valentina/attachments/20090807/67785eb5/attachment.html