>What is SET TABLEVALIDATE setting in your application? See if mskb #
293638 BUG: Header corruption causes END TRANSACTION to discard appended records is relevasnt to your problem. See
INFO: Data Reliability Enhancements in Visual FoxPro 8.0 mskb #
814131 for additional info.
SET TABLEVALIDATE is set to 3 and I am using VFP 8, so in the event of header corruption, I should get an error message when END TRANSACTION was issued but I didn't get it. I ran the sample code from mskb #
293638 that did give an error message.
However I did pack and reindex the table in question, it now seems to accept records after END TRANSACTION.
Thanks for the pointers!
Dawa Tsering
"Do not let any unwholesome talk come out of your mouths,
but only what is helpful for building others up according to their needs,
that it may benefit those who listen."
- Ephesians 4:29-30 NIV
Dare to Question -- Care to Answer
Time is like water in a sponge, as long as you are willing you can always squeeze some.
--Lu Xun, Father of Modern Chinese Literature