Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Why last record update by view1 not seen in requery view
Message
 
 
To
15/04/2008 15:53:13
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:
01310917
Views:
24
What's buffering mode for the table?

>
>I have a situation were
>
>(1) two views are opened againest the same table in the same datasession.
>
>(2) View_1 is requery'd and then every record has one column changed using "replace all" and then =tableupdate() is issued. (setting is optomistic Row Buffering)
>
>(3) View_2 is requery'd for basically the same data and all the updated column changes are seen EXCEPT in the last record where the updated column is still blank.
>
>I've tried FLUSH, and other ideas but only get the correct data if I close view_1 and the table before View_2 is requery'd or have view_2 closed and open fresh after the update has occured.
>
>Does anyone know what the issue is between the two views? Is it a Foxpro limitation, etc.
>
--sb--
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform