G'day Gavin,
Now I know where the .tdx came from, although I can't see a real reason for deviating from the default of .idx.
I thought that perhaps there was some significance in the naming of the index file, since the 't$000000' name is not very intuitive, to me, anyway. The '$' isn't seen in file names very often unless it's a special identifier. Thought it might have been a precursor to Hungarian Notation. Looks like this one gets chalked up under the heading of "Programmer Quirks".
Thanks, mate.


>Hi Pete,
>
>Take from the Help for INDEX in FPD2.6a:
>

>You can create an .IDX index file by including the TO idx file clause. The
>index file is given the default extension .IDX, which can be <b>overridden by
>explicitly including a different extension or by changing the default index
>extension in the FoxPro configuration file</b>.  Standard MS-DOS rules for
>naming files must be observed when creating index files.
>

>
>All 'INDEX ON acct_no TO t$000000.tdx' is doing is creating an IDX type index called 't$000000.tdx' on field 'acct_no' giving the index file an extension of .TDX instead of .IDX.
>
>Hope this helps,
>Gavin...
>
>>Hi all,
>>I'm working in FPD 2.6a on someone else's code from 1994(!) and bumped into this line of code. I can't seem to locate any Fox info on it.
>>
>>INDEX ON acct_no TO t$000000.tdx
>>
>>1. Does anyone know where this line may have been inherited from? I found "My Database" DOS uses .tdx. Is there a better suspect?
>>2. If it's not from Fox, did it exist at some former, lower level so that it is recognized by FPD 2.6a? The program does run nicely.
>>
>>TIA,
>>Pete