Diagnose problem

[Ruslan Zasukhin]

On 8/7/09 11:01 PM, "Richard McCoy" <mcrmedia1 at insightbb.com> wrote:

Hi Richard,

* This list do not allow attachments, so I do not see them.

* your table keep plain english ?

* you can try CLONE DB, to try repair it.

Let me know. May be send DB offlist in ZIP


> 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
> _______________________________________________
> Valentina mailing list
> Valentina at lists.macserve.net
> http://lists.macserve.net/mailman/listinfo/valentina

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