What is the difference between XG? and YG? files. I know that both compose
the secondary index, but why are there two files?
Also, what is the difference between the .X??/Y?? and .XG?/.YG? files ? Both
are secondary indices, but what is the significance of the "G"?

Thanks in advance for any pointers.

Ramon

The xnn and ynn files have the same relation as the .db file and the .px
file. If you rename the xnn file to .db, you can open it as a table. This
table contains all columns from the secondary index and the primary key
column and a column named Blk Num.

The nn which is a hex number can be in the range 01-nn and then it tells
you which column the index is based on. If nn > FF, then it is a compound
index, or a case insenistive or a not maintained single field index.

--
Bertil Isberg - CTECH
Paradox buglist:
online: http://web.comhem.se/~u82608896/

"RamonS" <you (AT) me (DOT) gov> skrev i meddelandet
news:44579e94$1 (AT) pnews (DOT) thedbcommunity.com...