>>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

Only in case something changes directly table and want to allow users to revert these changes. When you use views, use views and queries only and not directly tables. Access table as for read-only data, for example, do lookup(), seek() or simple query (last thing is better for case in future application will move to SQL Server or other backend).