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
15/04/2008 17:32:44
 
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:
01310920
Views:
22
>What's buffering mode for the table?

My global default setting for buffering is record optomistic (views and tables).

>
>>
>>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.
>>
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform