How can I detect table indices corrupt. then, auto rebuild?

[professionals]

My name is Moises,

I would like to know if somebody to help me on how to fix the indices while processing mode or an auto rebuild indices while on heavy processing on a shared mode level.

I mean it will automatically broadcast message first to all users before continuing the processing of any data.

Thank's in advanced.

 

[ramani]

HI

Here more than one issue in your question ...

1. To identify, a table index corrupt..
a. If it is corrupt to the extend, VFP can report -
Yes - you get the message from VFP and
thru error trap you can capture it.
b. At times the index is corrupt and VFP cannot report
- Only you get odd and wrong reports or errors
not directly indicating INDEX damage.
So when some such odd matter is noticed,
you do a reindexing

2. How to auto identify the index components and rebuild index - See in FAQ by clicking on this link
ReBuild your CDX index files
faq184-1033
Note .. you need an exclusive opening of the table.

3. "automatically broadcast message first to all users before continuing the processing of any data"....
See another FAQ by me to auto shut users..
A way to force Users out of your VFP application.
faq184-3152









ramani
(Subramanian.G)

http://winnersoft.coolfreepages.com/

 

[Mike Lewis]

Professionals,

If you have FoxPro Advisor, check my article on managing table structures in the August issue. It explains how I detect corruption and deal with it run-time.

My solution involves using Stonefield Database Toolkit, but even if you don't own that product, you can use the same techniques for detecting corruption.

Mike


Mike Lewis
Edinburgh, Scotland

http://www.ml-consult.demon.co.uk