>When I add and change records in a local updateable view and issue =TABLEUPDATE(.T.) and then REQUERY(), why do I get this error? By issuing =TABLEUPDATE(.T.) prior to REQUERY(), shouldn't the view's data be updated and buffer committed?
Is the view used in a form with a private data session? Make sure you also include SET DATABASE TO MyDBC. Many sets are scoped to the data session. I had the same problem you are having because I did not take care of that particular set. I do not know why this made a difference since my views and tables were linked to the DB, but these errors disappeared when I included the SET DATABASE TO MyDBC in my form load event.
Mark McCasland
Midlothian, TX USA