General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Network:
Windows 2000 Server
>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
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only