Re: HELP :Updateable VIEWS

From: Sven-Olaf Kelbert <kelbert_at_opitz-partner.de>
Date: Wed, 23 Feb 2000 14:28:16 +0100
Message-ID: <38B3E070.C8C7F339_at_opitz-partner.de>

Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit

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.
--------------6479EDE00379EE3A5ABFB440
Content-Type: text/x-vcard; charset=us-ascii;  name="kelbert.vcf"

Content-Transfer-Encoding: 7bit
Content-Description: Card for Sven-Olaf Kelbert
Content-Disposition: attachment;

 filename="kelbert.vcf"

begin:vcard
n:Kelbert;Sven-Olaf

tel;cell:+49 (0) 179 - 3941308
tel;fax:+49 (0) 2261 - 6001 - 61
tel;home:+49 (0) 221 - 9840094
tel;work:+49 (0) 2261 - 6001 - 56

x-mozilla-html:FALSE
url:http://www.opitz-partner.de
org:OPITZ & PARTNER GmbH
version:2.1
email;internet:kelbert_at_opitz-partner.de title:Dipl.Math.
adr;quoted-printable:;;Kirchstr. 6=0D=0A;51647 Gummersbach;;; x-mozilla-cpt:;26048
fn:Sven-Olaf Kelbert
end:vcard

--------------6479EDE00379EE3A5ABFB440-- Received on Wed Feb 23 2000 - 14:28:16 CET