What type of environment is your system running, an office, manufacturing plant,etc ?
>I have a database and a customer table in it. There is no unique,primary nor candidate key for the table,
>just several regular indexes. When i issued following code to append the table:
>
>=CursorSetProp("Buffering",5,"Customer")
>Insert into Customer (Fields) values (Values)
>Begin Transaction
>=TableUpdate(.T.,.T.,"Customer")
>End Transaction
>
>There is no record appended to the table and if i issue "set order to ..." command and browse the table,
>I got "Index does not match the table. Delete the index file and re-create the index" message.
>
>Then i tried several method to re-create the index:
>1. Issue command "Reindex".
>2. Issue command "Delete Tag All", then "Index on" each regular index field to re-create index.
>3. Just delete the .CDX file, then Validate the database, then "Index on" each regular index field to re-create index.
>The table looks fine after i re-create the index, except that the record i've just appended is gone. However, when i
>issue the codes to append record, i got the same error again.
>
>This problem occationally pops up, it is hard to track when it occurs. There is one thing interesting that
>if i do not use Begin Tran...Tableupdate...End Tran sequence, the record can be successfully appended to the table.
>
>I just want to know why this happens, how to prevent it and how to recover from it. I've been struggled in this for
>several months and just want to get out of this mess. Thank you very much for your kind attention.
Ken Wardwell