>>When an updatable view is based on a table that is buffered with OPT 3, how does the tableupdate() work? If I issue table update on the view, am I just updating the buffer of the base table, or is the tableupdate() on the view updating the base table. If the tableupdate() on the view is updating the buffer on the base table i would assume that I still need to issue the tableupdate() on the base table. Am I thinking about this correctly? Confused and befuddled.
>>
>>TIA.
>>
>>John.
>
>John,
>
>I tired a pretty simple test. Any update to the view was pushed back to the base table no matter which opt. buffering I used.
>
>-Mike

Hi Mike,

Thanks for responding!

This application is a multi-user app with a good chance of user collisions. So, when I update the 'view' with tableupdate() I should check for update errors at that time for the base table? Also another thought is if the base table is buffered and there has been some updates to that buffer, and at the same time the view is modified and tableupdate() is issued, it sounds like I could possibly have an update conflict to deal with when I issue a tableupdate() on the base table. Is that right? Would it be less confusing to take buffering off when using an updateable view?

I hope this message makes sense. I'm having trouble understanding this.

Thanks,

John