Reindex Success?

[Ruslan Zasukhin]

On 6/10/04 8:23 PM, "Keith DeLong" <delong at redcort.com> wrote:

Hi Keith,

> I'm trying to switch from deleting the .ind file to using the reindex
> command for my V4RB 1.10 db.
> 
> How can I tell if a reindex was successful?
> 
> I am doing the following:
> 
> dim res as integer = myDB.SqlExecute("REINDEX DATABASE")
> msgbox str(res) + EndOfLine + myDB.errstring
> 
> 
> I get res = 0 and a string of 'no error'
> 
> However the modification date of the .ind file does not change.

That is right. REINDEX do not trash .ind file, because it may contain files
that are not indexes.

It simply rebuild index after index.

> So I tried:
> 
> dim res as integer = myDB.SqlExecute("Do Nothing")
> msgbox str(res) + EndOfLine + myDB.errstring
> 
> Again, I get res = 0 and a string of 'no error'
> 
> What am I missing?

You know, it looks you have raise good question.

Right now it is not possible to see if it was done fine.

Btw, in 2.0  we will get working diagnose() for indexes!
This will allow us open eyes: if index is good now.


-- 
Best regards,
Ruslan Zasukhin      [ I feel the need...the need for speed ]
-------------------------------------------------------------
e-mail: ruslan at paradigmasoft.com
web: http://www.paradigmasoft.com

To subscribe to the Valentina mail list go to:
http://lists.macserve.net/mailman/listinfo/valentina
-------------------------------------------------------------