Trapping index errors

[Ruslan Zasukhin]

On 12/19/04 7:24 PM, "jda" <jda at his.com> wrote:

> I'm finding that index damage is the most common form of db
> corruption. I'd like to trap for that when opening a database and
> automatically rebuild the indexes.
> 
> I have a db with an index error of 537857 ($83501) -- Inventory
> corrupted for index "%S".
> 
> I've tried trapping for a number of different EVErrors, and even
> 
> if theError.ErrorNumber >= EVError.IndexByteReclistCorrupted and
> theError.ErrorNumber <= EVError.IndexPageInventoryCorrupted then...

This should work.

Look into XML files.
BTW, use for this MS IE. It can show XML in nice way.
Or any other good XML Viewer

Errors make groups.
They are sorted.
So range search should work!

> but can't catch it.
> 
> I can of course trap for the error number I've given, but I'd like a
> more general solution.
> 
> Ruslan, what enumerated constants would you suggest I use to trap for
> repairable index errors?

And of course I need way to reproduce errors

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