When you create an index are you using
INDE ON field TAG tagname
or
INDE ON field TO tagname?
>>Having indexes update is an automatic process. Is this a sporadic problem or is it consistient? Are you index files in the same directory as your DBF's? How big is your data? Are you running out of disk space? Just some things to think about....
>
>The problem is consistient but it happens on different dbfs every time and not on the same particualar dbf. Moreover, during updations, we are not removing the order on any field and updating the dbf with the order set. In this process, the field value might also change and therefore Foxpro has the double job of verifying the new value in the field and update the index file. Is this the cause of the trouble. ?
>
>The index files are in the same directory as dbfs
>Data is not much. 2 to 3 MB
>There is lot of disk space
>
>>
>>>There are a few permanent indexes on some of the dbfs. We have observed that these indexeses are not getting updated sometimes.
>>>
>>>Questions
>>>
>>>1. What could be the possible reasons for such a behaviour.
>>>
>>>2. What is the correct way of working with dbfs that have permanent indexes during insertion, Updation & deletion
>>>
>>>3. Should we re-index all the dbfs while starting the s/w. I personally feel this should not be necessary.
>>>
>>>4. Where can I find articles on indexing and its problems.
>>>
>>>Thanking you,
>>>
>>>Rakesh Kothari