From francois.tete@stream-core.com Mon Mar 29 08:33:56 1999 Received: from morgane.oleane.net (Morgane.OLEANE.Net [194.2.1.9]) by hub.org (8.9.2/8.9.1) with ESMTP id DAA51897 for ; Mon, 29 Mar 1999 03:33:56 -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 KAA09157 for ; Mon, 29 Mar 1999 10:33:54 +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 KAA02554 for ; Mon, 29 Mar 1999 10:33:52 +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 KAA04308 for ; Mon, 29 Mar 1999 10:30:23 +0200 Reply-To: "Francois TETE" From: "Francois TETE" To: Subject: inheritance and update Date: Mon, 29 Mar 1999 10:34:45 +0200 Message-ID: <01be79be$ff8c8960$070010ac@ft.gennevilliers.stream-core.com> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0021_01BE79CF.C3155960" 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 Message en plusieurs parties et au format MIME. ------=_NextPart_000_0021_01BE79CF.C3155960 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable 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=20 2 | bill But I can't update the tables using the following query : update BASE* set name=3D'john' where id=3D1; Is there another means to do such an update ? Thank you for any answer. Francois=20 --- 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 ------=_NextPart_000_0021_01BE79CF.C3155960 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
Is it possible to update rows in a = derived class=20 via the base class ?
 
I have a base class, let's say BASE and two derived = tables=20 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=20 following query :
update BASE* set name=3D'john' where = id=3D1;
 
Is there another means to do such an = update=20 ?
 
Thank you for any = answer.
 
Francois 
 
---
Francois = TETE
StreamCORE
2 place=20 des Hauts Tilliers - 92632 Gennevilliers Cedex - France
  Mail : = francois.tete@stream-core.c= om
 =20 Phone: +33 1 41 21 46 22
  Fax  : +33 1 41 21 46=20 27
 
------=_NextPart_000_0021_01BE79CF.C3155960-- From francois.tete@stream-core.com Mon Mar 29 08:40:50 1999 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