Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
TableUpdate not committing records with Op Table Bufferi
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 8 SP1
OS:
Windows XP SP2
Network:
Windows 2000 Server
Database:
Visual FoxPro
Miscellaneous
Thread ID:
00994219
Message ID:
00994673
Views:
25
>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

Previous
Next
Reply
Map
View

Click here to load this message in the networking platform