Tom;
See my reply to Mike. I frogot to copy you on it. I don't know if that is your problem but it had some of the same symptoms and drove me batty fro a while. HTH
>I have a table that has a view with optimistic table buffering(View1) and a view based off of that view that is also optimistic table buffered(View2).
>Add a record to View2. TableUpdate() View2, then TableUpdate() View1.
>The changes appear in the table.
>When I do a requery() of View1, the changes appear, BUT when I do a requery() of View2 the changes are not there.
>If I were to add another record doing the same process, the first record will then appear in View2 BUT the newly added record now doesn't show.
>NOTE: - FLUSH doesn't seem to solve the problem.
> - Closing the table and resetting the buffering works but then I'm unbinding the object.
>
>Anyone come across this problem?
>
>Tom W.
***************************
Bruce Gilmour
"Two things are infinite, the Universe and human stupidity. And I am not sure about the Universe."
- Albert Einstein