<html><head></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; ">Hi Ivan,<div><br></div><div>yes, this is during adding records. No, there are no records deleted. Is it possible that I'm missing a flush somewhere?</div><div><br><div><div>On 17.06.2011, at 07:51, Ivan Smahin wrote:</div><br class="Apple-interchange-newline"><blockquote type="cite"><span class="Apple-style-span" style="border-collapse: separate; font-family: Helvetica; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-border-horizontal-spacing: 0px; -webkit-border-vertical-spacing: 0px; -webkit-text-decorations-in-effect: none; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; font-size: medium; "><blockquote cite="mid:024B19C4-58DE-4E6C-A76E-719EAF9BEC58@gmx.de" type="cite"><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-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; font: normal normal normal 10px/normal 'Lucida Grande'; ">Field: MessageBody. Index record count (26064) differ from field one (25924).</div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; font: normal normal normal 10px/normal '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.</span></blockquote></div><br><div>
<span class="Apple-style-span" style="border-collapse: separate; color: rgb(0, 0, 0); font-family: Helvetica; font-size: medium; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-align: auto; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-border-horizontal-spacing: 0px; -webkit-border-vertical-spacing: 0px; -webkit-text-decorations-in-effect: none; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; ">Mit freundlichen Grüßen/Regards<br><br>Trixi Willius<br><br><a href="http://www.mothsoftware.com">http://www.mothsoftware.com</a><br>Mail Archiver X: archive, clean and search email<br>http://www.beatrixwillius.de<br>Fractals, 3d landscapes etc.</span>
</div>
<br></div></body></html>