chpicker
Programmer
- Apr 10, 2001
- 1,316
I have a table that has been around for a very long time without problems. It was decided to add another index to this table. The index expression is:
namefield+ttoc(timefield)
This index is intended to organize the table in order by the customer's name, and order each customer's records by the time field. This works...for the most part.
The weird problem that I'm seeing is when I'm browsing the table in a grid. When I activate the index tag mentioned above and scroll through the table, the records sometimes jump around...and eventually I'll find a "duplicated" record in the table that I can't move the cursor down to (it jumps the cursor back up to the original). The record isn't actually duplicated, but the index is making the system THINK it is. My guess is it's a corrupted index file, but I've tried deleting the index and recreating, and I've tried deleting the .CDX file and recreating ALL of the indexes. It still happens. Any ideas on what could be causing this?
namefield+ttoc(timefield)
This index is intended to organize the table in order by the customer's name, and order each customer's records by the time field. This works...for the most part.
The weird problem that I'm seeing is when I'm browsing the table in a grid. When I activate the index tag mentioned above and scroll through the table, the records sometimes jump around...and eventually I'll find a "duplicated" record in the table that I can't move the cursor down to (it jumps the cursor back up to the original). The record isn't actually duplicated, but the index is making the system THINK it is. My guess is it's a corrupted index file, but I've tried deleting the index and recreating, and I've tried deleting the .CDX file and recreating ALL of the indexes. It still happens. Any ideas on what could be causing this?
