Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Why last record update by view1 not seen in requery view
Message
From
16/04/2008 09:37:19
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 7 SP1
OS:
Windows XP SP2
Network:
Windows 2000 Server
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01310893
Message ID:
01311071
Views:
18
>>>What's buffering mode for the table?
>>
>>My global default setting for buffering is record optomistic (views and tables).
>
>Yoyu should tun of buffering for the table when you're using views to update it. Otherwise you'll have to issue tableupdate on the table after tableupdate on the view.

Actually, I only have buffering on the views (buffer mode = 3) and the tables are (buffer mode = 1).

The unusual aspect of this problem is that all records are being updated except the last one after Requirying view_2. I can open the updated table and see the updated last record in it, but view_2 doesn't show the updated last record. After the table is browsed and closed, requirying view_2 will return showing the last record updated.
Previous
Reply
Map
View

Click here to load this message in the networking platform