>An integer takes four bytes in an index and the table. BINTOC() creates a 4-character string which also takes 4 bytes. You can't compress an integer index any further.
>
>Christof
That's what I originally thought. If you look at the solution.app that comes with VFP it tells a different story; namely, that index sizes go in the following order:
Int = C(8) = str(Int) > N(8) > BINTOC(N(8)) = BINTOC(Int)
I just tried making all four indexes STR(Int) and it doubled the index size. Obviously, solution.app is wrong. Only BINTOC( , 1) or BINTOC(,2) would be an improvement over integer. Thanks for your help.
----------
Mark Bucciarelli