Christof,
I just ran this test code, I tried 2^i, 2^i - 1 and 2^i + 1
create table itest (i1 i)
index on i1 to itest.idx
for i = 0 to 30
j = 2^i + 1
insert into itest values ( j )
endfor
use
Used a hex file viewer between each run and it does look like bintoc() is stored in the idx. Which is somewhat suprising. There's no word/byte swapping like the integers have in the .dbf itself. So maybe FoxPro is playing some other tricks that make this the fastest way to deal with the index file.
>Only in a compact index. Have you tried to analyze a non-compact IDX index? I think it would be easier with such an index...