Received: from morgane.oleane.net (Morgane.OLEANE.Net [194.2.1.9]) by hub.org (8.9.2/8.9.1) with ESMTP id DAA53404 for ; Mon, 29 Mar 1999 03:40:50 -0500 (EST) (envelope-from francois.tete@stream-core.com) Received: from tom.oleane.net (tom.oleane.net [194.2.28.14]) by morgane.oleane.net with ESMTP id KAA10259 for ; Mon, 29 Mar 1999 10:40:48 +0200 Received: from stream-core.com (dyntnt-1-015.Def.dialup.oleane.fr [195.25.5.15]) by tom.oleane.net (8.8.8/8.8.8) with ESMTP id KAA07363 for ; Mon, 29 Mar 1999 10:40:46 +0200 Received: from ft.gennevilliers.stream-core.com (ft [172.16.0.7]) by stream-core.com (8.8.5/8.8.5) with SMTP id KAA05174 for ; Mon, 29 Mar 1999 10:37:43 +0200 Reply-To: "Francois TETE" From: "Francois TETE" To: Subject: Inheritance and update Date: Mon, 29 Mar 1999 10:42:05 +0200 Message-ID: <01be79c0$06357140$070010ac@ft.gennevilliers.stream-core.com> MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 4.71.1712.3 X-MimeOLE: Produced By Microsoft MimeOLE V4.71.1712.3 Is it possible to update rows in a derived class via the base class ? I have a base class, let's say BASE and two derived tables DERIVED1 and DERIVED2. Suppose that select * from DERIVED1; returns : id | name 1 | joe and select * from DERIVED2; returns : id | name 2 | bill So select * from BASE*; returns as expected id | name 1 | joe 2 | bill But I can't update the tables using the following query : update BASE* set name='john' where id=1; Is there another means to do such an update ? Thank you for any answer. Francois --- Francois TETE StreamCORE 2 place des Hauts Tilliers - 92632 Gennevilliers Cedex - France Mail : francois.tete@stream-core.com Phone: +33 1 41 21 46 22 Fax : +33 1 41 21 46 27