Re: HELP :Updateable VIEWS

> Hello:
>
> How can i have a updateable view in the detail part of a master-detail
> form ?
> Isn't true that if a view contains the primary keys of the tables, they
> can be updated ?
> I've got a error "...blabla... non key-preserverd"...
>
> Can anyone help ?
>
> mail me please :)
>

select *
from USER_UPDATABLE_COLUMNS
where table_name = <view_name>

now you can see, which columns are updatable in your view.

Regards, Stephan

--
---------------------------------------------------------------
Dipl.-Inf. (FH) Stephan Born   | beusen Consulting GmbH
fon: +49 30 549932-0           | Landsberger Allee 392
fax: +49 30 549932-21          | 12681 Berlin
mailto:stephan.born_at_beusen.de  | Germany
---------------------------------------------------------------
       PGP-Key verfügbar       |      PGP-Key available
---------------------------------------------------------------