Thanks Jim,
I did not know that views could not have pessimistic buffering. That solved my problem. Now I can get back to the original problem I had!