Re: HELP :Updateable VIEWS

Hi Joao!

"Joao Ricardo B. Oliveira" wrote:
>
> 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 ?

No! Only that table is updatable from which the primary key is also the primary key of the view. You can check that with the SQL-Statement

select column_name, updatable
from user_updatable_columns
where table_name = 'TABLE_NAME'; <- insert the name of your view

> I've got a error "...blabla... non key-preserverd"...
Then you have to verify, that all items which belongs to an non-keypreserved table (that tables, which primary keys are not the primary key of the view) get the property "query only = yes", to perform no insert/update on them.

Greetings,
Sven-Olaf Kelbert.

Received on Wed Feb 23 2000 - 07:28:16 CST