>Hi!
>
>If table is also in buffering mode, you require to issue tableupdate() for table only. When data are buffered for table, SELECT-SQL statement (it is ran by View2) cannot get these new data from memory buffers. SELECT in VFP works for phisical data only.
>
>It is recommended to keep tables with no buffering and use buffering only for views.
>
>>Two views with the same base table. All are optomistic row buffered. Value changes in View1 and TableUpdates are successfully done on View1 and the base table. When View2 is requeried the changed value does not exists. View2 must be updated also. Why? If the base table value has changed shouldn't a Requery of View2 include the changed value? Thanks!
>>
>>Regards, Renoir

Hi Vlad,

Ok, I removed the buffering on the table and only update the view and that worked; Requery works fine for all views. Thanks! One follow-up question - I thought that there were certain situations that required that the base table be buffered. Do you know any times when that is true?

Renoir