Hi,

I have an OnStatusMessage setup on a TEDBQuery component.

When I run say "REPAIR TABLE purpose" the status messages speak of
verify but no mention of repair... Is the table getting repaired OR
verified OR is the MessageStatus incorrect in the source code? Optimise
appears to give the correct messagestatus.....

Verifying the table purpose...
Verifying the table purpose - Verifying rows (structure-only)...
Verifying the table purpose - Verifying index PrimaryKey (structure-only)...
Verifying the table purpose - Verifying table contents (logical)...
The table purpose was verified successfully

Phil


As a guess there was no fault to repair.

Roy Lambert [Team Elevate]

Phil,

<< When I run say "REPAIR TABLE purpose" the status messages speak of verify
but no mention of repair... Is the table getting repaired OR verified OR is
the MessageStatus incorrect in the source code? Optimise appears to give the
correct messagestatus..... >>

The messages are correct - the repair works by verifying the table and, if
any errors are found, then you'll see a "fixed xxxx" type of message.

If you have any other questions, please let me know.

Tim Young
Elevate Software
www.elevatesoft.com

> The messages are correct - the repair works by verifying the table and,
> if any errors are found, then you'll see a "fixed xxxx" type of message.
>
> If you have any other questions, please let me know.

No that's fine, I wanted check it was right cause it's just alittle
confusing in a program using these status messages as it's identical to
the verify and doesn't mention 'nothing to repair' or even the word
repair, but all good I just wanted to make sure. I didn't have a broken
table to test with.

Thanks,

Phil