General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Updating a table in 2.5a DOS and VFP5 - index problems!
I have a question regarding possible incompatibilities between FoxPro 2.5/2.6 tables/CDXs and table mods in VFP5/6:
We are currently doing all our table structure mods (i.e. packing/reindexing) in FoxPro 2.5a (DOS). We are also doing INSERT - SQL statements into the table in question from both 2.5a DOS and VFP5 (potentially concurrently), as well as a REPLACE and a DELETE from VFP5 only. There is one regular CDX index on the table in question - on a single numeric field (no filter on the index).
What is happening on a regular basis is that the INSERTs from 2.5a DOS are inserting a record, but the record does not show up when the table is set to the index order (as if it never updated the index for that record). This behavior only seems to happen to one out of maybe every several hundred records.
What I am wondering is if this is a symptom of a problem with a VFP change being incompatible with 2.5a tables However, we are only doing an INSERT, REPLACE, and DELETE from VFP5 - no other types of table mods. Can you not do INSERTs from both versions into the same table (assuming it is a 2.5a table) - and could the problem be caused by two different users with different FoxPro versions INSERTing to the table simultaneously? Again, note that reindexing of this table happens only under 2.5a DOS
Just wondering if I am doing something it was not built to do.
Thank you (in advance) for your assistance.
-- Trevor Feldman
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only