<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
On 6/17/2011 8:51 AM, Ivan Smahin wrote:
<blockquote cite="mid:4DFAEB51.8050009@paradigmasoft.com"
type="cite">
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
<title></title>
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>
</blockquote>
<br>
Ups, sorry. It seems to be a "class way". I meant - index is created
just after table.CreateField() or db.Create in "class way" case.<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>