Diagnose problem

[Richard McCoy]

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/0db99cb8/attachment-0001.html