You know that I'm not buffering expert, but when I open DE I see that even there's no option to set BufferMode for view to pessimistic. I didn't try CURSORSETPROP(), so I don't know will you get error or something else. Again, there is no reason (IMO) to set or try to set pessimistic buffering on view.
>So, nobody uses pessimistic buffering on views? Ever? For any reason? Or are you saying the view has no table header to _lock_? Would pessimistic buffering lock...what then? Or would it give me an error?
>
>>You hit the target: there is no valid reason to put pessimistic buffering on views, because a view (cursor by nature) is already in exclusive possession of the user. Each user gets own recordset, there is nothing to lock.
Edward Pikman
Independent Consultant