I never seen this before. I issue the following cammand

in TCL "LIST INVOCE_FILE BY @ID" and a good number

of records are skipped but yet I can look at them

in editor. I don't know what the problem is. Please help.

David:

If you have a B-Tree index on @ID, then it's probably corrupted. If you have a Quickdex/Rightdex on the Table, it may have overflowed. There is a 64K limit on the size of the %RECORDS% field. You can check these condtions by: Using DUMP to get the supposed record count from the table. Then do an R/LIST Select using the Index. If you don't get the same number of records, then the index is bad. You can also do a FORM-LIST on the table using %RECORDS%. If you don't get the correct # of records then the Quickdex/Rightdex is broke.

Don Miller

Don,

Thanks Don it was the Quickdex/Rightdex problem.

Thanks again.

View this thread on the forum...