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 phisycal 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 optimistic 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
Vlad Grynchyshyn, Project Manager, MCP
vgryn@yahoo.comICQ #10709245
The professional level of programmer could be determined by level of stupidity of his/her bugs
It is not appropriate to say that question is "foolish". There could be only foolish answers. Everybody passed period of time when knows nothing about something.