I have a situation where under certain circumstances five tables in my DBC do not update their structural CDX indexes when a new record is added. There are 30+ other tables in the CDX which work fine.
When this happens I can't find the new record using any of the CDX indexes but I can find it by record number.
If I issue a REINDEX command then I can find the record from any of the indexes.
This only happens from a form (any form for one of these tables) which I build in Visual Fox Express. If I add a record from the command line the indexes are updated properly. If I add a record programmatically using the same method as the VFE form -- optimistic table buffering, CURSORSETPROP("BUFFERING",3) and TABLEUPDATE(), the problem does not happen.
If I create an identical table with a different name, insert it into the DBC, build a form in VFE, etc, the problem does not happen.
I'm suspecting something flakey in my DBC or DBCX.
I'm working with Toni and Mike Feltman on this but I would appreciate hearing from anyone who has seen a situation where a structural CDX was not updated properly.
Peter Robinson
Peter Robinson ** Rodes Design ** Virginia