Index corruption on database close

[Steve Albin]

cCatnum is a VarChar of 100 bytes.  The cTitleIdx that I'm using along with it in the SQL is also VarChar and 504 bytes.  

I submitted a Mantis report that has a link to a copy of my database if you would like to have a look.  My situation is reproducable with that database and one other that I had, but oddly, not with a third different database.  The only thing I could see on the third database was that there were very few duplicate fields.

http://www.valentina-db.com/bt/view.php?id=6899

Steve

--
Steve Albin, Montclair, NJ
http://www.steve-albin.com
http://www.jazzdiscography.com

On Jul 22, 2014, at 12:43 PM, Beatrix Willius <bwillius at gmx.de> wrote:

> 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
> 
> _______________________________________________
> Valentina mailing list
> Valentina at lists.macserve.net
> http://lists.macserve.net/mailman/listinfo/valentina