<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
<title></title>
</head>
<body bgcolor="#ffffff" text="#000000">
On 6/16/2011 6:48 PM, Beatrix Willius wrote:
<blockquote cite="mid:024B19C4-58DE-4E6C-A76E-719EAF9BEC58@gmx.de"
type="cite">Hi,
<div><br>
</div>
<div>how and when exactly are indices created?</div>
<div><br>
</div>
<div>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:</div>
<div><font class="Apple-style-span" size="2" face="'Lucida
Grande'"><span class="Apple-style-span" style="font-size:
10px;"><font class="Apple-style-span" face="Helvetica"><span
class="Apple-style-span" style="font-size: medium;"><br>
</span></font></span></font></div>
<div>
<div style="margin: 0px; font: 10px 'Lucida Grande';">Field:
MessageBody. Index record count (26064) differ from field one
(25924).</div>
<div style="margin: 0px; font: 10px 'Lucida Grande';">Problems
found! ( Table: Message )</div>
<div><br>
</div>
<div>MessageBody is a Text field:</div>
<div><br>
</div>
<div>dim MessageBody as VText = new VText("MessageBody",
1*1024, EVFlag.fIndexed + EVFlag.fIndexByWords)</div>
<div><br>
</div>
</div>
</blockquote>
Index will be created just after this call.<br>
Then, I guess, you are adding some records and judging on the
diagnose message there is some "delete records" as well.<br>
And finally some crash before db.Flush?<br>
<br>
<blockquote cite="mid:024B19C4-58DE-4E6C-A76E-719EAF9BEC58@gmx.de"
type="cite">
<div>
<div>When writing to MessageBody I do the following:</div>
<div><br>
</div>
<div>
<div> theCursor.field("MessageBody").setString theNewBody</div>
<div> theCursor.UpdateRecord</div>
<div> theCursor.SetBlank </div>
<div> theCursor.Database.Flush</div>
</div>
<div><br>
</div>
</div>
</blockquote>
SetBlank is about to set all field values to zero. Why do you need
this call before db.Flush?<br>
Meanwhile it is not a problem - just looks like redundant.<br>
<br>
<br>
-- <br>
<pre class="moz-signature" cols="72">Best regards,
Ivan Smahin
Senior Software Engineer
Paradigma Software, Inc
Valentina - The Ultra-Fast Database
<a class="moz-txt-link-freetext" href="http://www.valentina-db.com">http://www.valentina-db.com</a></pre>
</body>
</html>