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.


>I have Data Environment Class, the process is as follows:
>1. open the database in BeforeOpenTables
>2. use all tables with buffering set 5 (Optimistic Table Buffering)
>3. attach the DE class to a private data session form
>4. on the form, I have a method called DeleteBill which deletes records from various related
> tables, then the method calls another method which inserts a record in a table. After that
> the changes are committed to the tables using TableUpdate. The following is the code
> structure:
<snip>
>
>Changes in table1,table2 were committed but not in table3.
>I was able to browse table3 and see the inserted records when probe into the table within that the data session of the form.
>
>Why is this happening? Has anybody encounterd something like this?