Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
First Local View
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00299992
Message ID:
00300018
Views:
27
Alan,

If you have both the table and the view buffered you have to do a tableupdate() on both. The best way to do this is to buffer your view and leave the table itself unbuffered. Then the tableupate on the view will update the actual table.

HTH

Jeff

>Hello,
>I working with a Local View for the first time and I'm running into a problem with the update. After I issue my TableUpdate() the new record seem to be there. I can recall it and edit it. When I exit the application, then go back in, it's gone! I'm using VFP 6.0 SP3. I have both the table and the view set-up ad 3-Optimistic Row Buffering. I've tried it with 5-Optimistic Table Buffering also. It seems that the View creates a temporary file, but it is never written back to the table. I have a primary key and all of the fields are marked for update in the View designer.
>
>What am I doing wrong?
>TIA
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform