>>Given an optimistic table buffered cursor against an updateable view:
>>
>>Suppose the cursor has already been queried , and changes made by the user.
>>
>>There is an existing record in the base table, that was not included in the query and thus is not in the cursor against the view.
>>
>>Is there a way to add this existing record to the cursor without requerying the view?
>>
>>My guess is no -- but there are people on this thread who do amazing things.
>
>Not without doing it manually. You can always open the base table in another work area, and SCATTER, GATHER into the view.
Thanks
I presume you means scatter, gather from the view into the base table. If I scatter, gathered into the view when I issue a tableupdate it will simply try to add the record a second time,violating the unique key.
Thanks
Gar W. Lipow