[ALL] Second project... SOLVED -- how to use EXPLAIN !

[Ruslan Zasukhin]

On 7/15/06 2:00 PM, "Stan Busk" <maxprog at mac.com> wrote:

 
> Ok, I will try that. The class has been updated. I guess The line:
> 
> vdb.Table("tblArticle").Field("Article_Newsgroups").IsIndexed = True
> 
> is enough to update schema , right?

Yes, but you use classes...

Where you want put this line of code ?


Valentina 2 do *strict* check that classes correspond to existed db files.
In the same time flag Indexed is not strict. Because it NOT change logic of
work of code..

So in your case you can



 
> Then I reindex the DB with:
> i = vdb.SQLExecute("REINDEX DATABASE")
> 
> Right?

Why to reindex ?

  vdb.Table("tblArticle").Field("Article_Newsgroups").IsIndexed = True

This self BUILD INDEX if it not exists
 
> Please confirm and I will try.
> 
> So, EVFlag.fIndexByWords has no effect without EVFlag.fIndexed if I
> understand well...

Yes. 

Idea is that you can temporary REMOVE index, then return it back.
But "index modifiers" are alive during this.


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