>>>My systems primary interface is FoxPro 2.5 DOS. I do a few things with FPW 2.6 and the rest with VFP5. The problem I have is I continuous have to reindex all my tables. Users add things into the table via DOS but I have to reindex at least once a day for the records to be show. Any hints as to why this is?
>>>
>>>Chris
>>
>>You are using structural indexes (.CDX)? Can users use something like dBase to add records to your tables, or otherwise bypass your app to add records?
>
>I'm using structural compound indexes. No, users can not use dBase or anyother non foxpro app to add records.
I would then have the same question as Dorris, plus are you using FPW 2.6 and VFP5 to access the tables as well? Or is it just FP 2.5 DOS that is accessing the tables? When you reindex, do you just open the table exclusively and issue a reindex command? If so, you should do a
Delete tag all
Pack (while your at it, optional)
Index on fieldexpression tag tagname
Index on Deleted() tag DelTagName
This prevents CDX bloating, and other potential corruption that may not be eliminated by a simple reindex.
Mark McCasland
Midlothian, TX USA