Index problem. (AREV Specific)
At 16 FEB 1998 01:28:18PM Jason Berney wrote:
I have a problem with indexes not returning all of the keys that they're supposed to.
We have an invoice table that is indexed on customer number. If I do a SELECT on the table for a specific customer it will return all but 3 of the invoices that it should. (There are over 8,400 invoices for this customer, could it be some sort of index size limitation?) If I manually edit one of these missing invoices, and manually change the customer number to something else entirely, I can do a SELECT and get that invoice just like it's supposed to. But when I change the customer number back to what it was originally, I can no longer select it with the 8400 other invoices. What gives?
At 16 FEB 1998 05:39PM Don Bakke wrote:
Jason,
Well there could be a few reasons for this. I just went through a somewhat similar experience and was shown that my problem was not having the dictionary item referencing my key having a length longer than the longest key.
At 17 FEB 1998 08:24PM Woody Woodbury wrote:
I have on going problems which are similar. If you search for the title "Index not returning all records in criteria", you will find a bulletin I posted on 12-29-97. I hope this helps.