<!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>Okay, I've gone into Valentina Studio 4 and used
the query:</FONT></DIV>
<DIV><FONT size=2 face=Arial></FONT> </DIV>
<DIV><FONT size=2 face=Arial>select * from Kwrd_List where KwrdName =
'Concert'</FONT></DIV>
<DIV><FONT size=2 face=Arial></FONT> </DIV>
<DIV><FONT size=2 face=Arial>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", <U>including</U> "Concert":</FONT></DIV>
<DIV><FONT size=2 face=Arial></FONT> </DIV>
<DIV><FONT size=2 face=Arial>select KwrdName from Kwrd_List where substring
(upper(KwrdName) from 1 for 1 = 'C'</FONT></DIV>
<DIV><FONT size=2 face=Arial></FONT> </DIV>
<DIV><FONT size=2 face=Arial>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.</FONT></DIV>
<DIV><FONT size=2 face=Arial></FONT> </DIV>
<DIV><FONT size=2 face=Arial>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.</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=mcrmedia1@insightbb.com
href="mailto:mcrmedia1@insightbb.com">Richard McCoy</A> ; <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 3:43
PM</DIV>
<DIV style="FONT: 10pt arial"><B>Subject:</B> Re: Diagnose problem</DIV>
<DIV><BR></DIV>
<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></BLOCKQUOTE></BODY></HTML>