Corrupt index

[Ivan Smahin]

On 6/16/2011 6:48 PM, Beatrix Willius wrote:
> Hi,
>
> how and when exactly are indices created?
>
> After adding data, my application does a diagnose. I now got the 
> second user reporting a problem. Today I got a diagnose report with 
> the following content:
>
> Field: MessageBody. Index record count (26064) differ from field one 
> (25924).
> Problems found! ( Table: Message )
>
> MessageBody is a Text field:
>
> dim MessageBody as VText = new VText("MessageBody",  1*1024, 
> EVFlag.fIndexed + EVFlag.fIndexByWords)
>
Index will be created just after this call.
Then, I guess, you are adding some records and judging on the diagnose 
message there is some "delete records" as well.
And finally some crash before db.Flush?

> When writing to MessageBody I do the following:
>
>     theCursor.field("MessageBody").setString theNewBody
>     theCursor.UpdateRecord
>     theCursor.SetBlank
>     theCursor.Database.Flush
>
SetBlank is about to set all field values to zero. Why do you need this 
call before db.Flush?
Meanwhile it is not a problem - just looks like redundant.


-- 

Best regards,
Ivan Smahin
Senior Software Engineer
Paradigma Software, Inc
Valentina - The Ultra-Fast Database
http://www.valentina-db.com

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.macserve.net/pipermail/valentina/attachments/20110617/b83cdae8/attachment.html>