<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META content="text/html; charset=iso-8859-1" http-equiv=Content-Type>
<META name=GENERATOR content="MSHTML 8.00.6001.18783">
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><FONT size=2 face=Arial>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!</FONT></DIV>
<DIV><FONT size=2 face=Arial></FONT> </DIV>
<DIV><FONT size=2 face=Arial>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.</FONT></DIV>
<DIV><FONT size=2 face=Arial></FONT> </DIV>
<DIV><FONT size=2 face=Arial>Thanks.</FONT></DIV>
<BLOCKQUOTE
style="BORDER-LEFT: #000000 2px solid; PADDING-LEFT: 5px; PADDING-RIGHT: 0px; MARGIN-LEFT: 5px; MARGIN-RIGHT: 0px"
dir=ltr>
<DIV style="FONT: 10pt arial">----- Original Message ----- </DIV>
<DIV
style="FONT: 10pt arial; BACKGROUND: #e4e4e4; font-color: black"><B>From:</B>
<A title=mcrmedia1@insightbb.com href="mailto:mcrmedia1@insightbb.com">Richard
McCoy</A> </DIV>
<DIV style="FONT: 10pt arial"><B>To:</B> <A title=valentina@lists.macserve.net
href="mailto:valentina@lists.macserve.net">Valentina Developers</A> </DIV>
<DIV style="FONT: 10pt arial"><B>Sent:</B> Friday, August 07, 2009 9:34
AM</DIV>
<DIV style="FONT: 10pt arial"><B>Subject:</B> Diagnose problem</DIV>
<DIV><BR></DIV>
<DIV><FONT size=2 face=Arial>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). </FONT></DIV>
<DIV><FONT size=2 face=Arial></FONT> </DIV>
<DIV><FONT size=2 face=Arial>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. </FONT></DIV>
<DIV><FONT size=2 face=Arial></FONT> </DIV>
<DIV><FONT size=2 face=Arial>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.</FONT></DIV>
<DIV><FONT size=2 face=Arial></FONT> </DIV>
<DIV><FONT size=2 face=Arial>Field: KwrdName. Index record count (2112) differ
from field one (2186).<BR>Field: KwrdName. Index have 74 missing
records.</FONT></DIV>
<DIV><FONT size=2 face=Arial></FONT> </DIV>
<DIV><FONT size=2 face=Arial>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.</FONT></DIV>
<DIV><FONT size=2 face=Arial></FONT> </DIV>
<DIV><FONT size=2 face=Arial></FONT> </DIV>
<DIV><FONT size=2 face=Arial>Thanks.</FONT></DIV>
<DIV> </DIV>
<DIV><FONT size=2 face=Arial>Richard McCoy<BR>Executive Creative
Director<BR>MCR Media Associates, LLC</FONT></DIV></BLOCKQUOTE></BODY></HTML>