I'm sorry if I've confused matters. I've developed a framework that uses views exclusively to access local tables (all free tables) or data stored in SQL server. It's become my new religion to never-ever open a table directly. Every one of my forms is free of any tables or views when it loads - all views are added from meta-data when the form loads - I even create my view DBC on the fly.
I checked my underlying SYSINFO.DBF table in the debugger and it reports a buffermode of 0 (none). Hmmm... Everything works FINE if:
a) I close the underlying table (that the view opened originally) right before I call the TableUpdate()
b) Change the type of table to FOX2X (you can't *make* me go back there..)
I have a view object that I use for all data access (think of a half-baked cursor adapter). After every requery() and before every PUT() I simply issue a USE IN SELECT("SourceTable"). That forces the view to re-open it's source fIt works, but I don't like it. I'll try to post some repro code over the weekend - this really shouldn't be happening.
Thanks for your time and tenacity!
Best Regards,
~Erik Folley