Re: update view..

sankar.jasti_at_gmail.com wrote:
> Hi,
> i struck with a prob in forms development.. please help me to
> solve...
>
> i have a form which is based on a view.
>
> the view which is based on a table, has functions like sum, addition
> and group by..
>
> when i tried to update table through form it says that it is not able
> to lock the record for update or delete.
>
> Thanks,
> Jasti.

With complex views the only way to perform an update through the view is to use an INSTEAD-OF trigger. Examples at www.psoug.org ... click on Morgan's Library ... click on INSTEAD-OF trigger.

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)