Hello,

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.

Gary Pike
Ics Systems, Inc.