thanks mike. that streamlines it a bit.
k
>>i am used to using idx files - a simple reindex command does the trick.
>>the cdx file has baffled me and i am just guessing on how to control it so bear with me.
>>i have set up auto complete name and find I keep getting old entries appear in my cdx file and wonder if there is a way to clear it out and start fresh.
>>I have tried delete tag name1 - which I assume would clear the old cdx - not so.
>>i am probably way off base but without changing course entirely is there a simple way to do this.
>>thanks
>>k
>>
>>
>>Procedure Load
>> Select 0
>> Use myfile.Dbf
>> INDEX ON vNAME Tag Name1
>> Set Order To Tag Name1
>> Endproc
>>
>
>Autocomplete does not extract any data from the idx or the cdx at all. The set order is not needed after an index command. CDX is the correct practice for Fox. IDX is way outdated. Not only is it outdated, but unless you add the COMPACT clause, the IDX is much larger. In your above code autocomplete will be grabbing data from myfile.dbf.
>
>You really should have issued the index command once - or as part of a maintenance thing. Not while opening the table. Then your system would only need
>
>select 0
>use myfile.dbf order tag name1
>
>So you'd write less code, have better performance and get work done faster yourself and for the users.