Index corruption on database close

Tue Jul 22 11:43:19 CDT 2014

What type of field is cCatnum? What exactly does the diagnose say about the corruption?

Reason I'm asking is that I've had occasionally non-reproducable index problems with Varchar fields.

On 21.07.2014, at 23:03, Steve Albin <steve at steve-albin.com> wrote:

> I then close the database and reopen.  Then I view the table and click on the cCatnum field header.  The indexing is corrupt.  I run the same SQL as above and the listed records seem to be ignoring the cCatnum field and only ordering on the cTitleIdx field.

Mit freundlichen Grüßen/Regards

Trixi Willius

http://www.mothsoftware.com
Mail Archiver X: The email archiving solution for professionals