Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Need help with views, record buffering and tableupdate()
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00343760
Message ID:
00344102
Views:
20
>>Using VFP5...
>>
>>I have a table (table1) set up with record buffering. I then create an updatable local view from it. I change a field
>>within the view and update as follows:
>>
>>View1 is made up of all records with table1.done<>.t.
>>
>>(for this example it finds one record so...)
>>
>>replace view1.done with .t.
>>=tableupdate()
>>
>>Now when I requery() looking for view1.done<>.t. (as before) the record I just changed still shows up as if the update never
>>happened. The update does happen when I exit the form. Can anyone clue me in to what I'm doing wrong?
>
>Both the view AND the table are buffered, so so need to issue 2 TABLEUPDATES, first the view, then the table. Better yet, don't buffer the table, then you just need 1 TABLEUPDATE, on the view.

What you suggested works. But for kicks I decided to try your "better yet" method. I turned off all buffering at the form property. I then
went to the DE and enabled optimistic row buffering on the view. It still exhibits the same behavior and I have to do the tableupdate
on both the view and table. Any more tips?
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform