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:
00343766
Views:
18
>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.
Chris McCandless
Red Sky Software
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform