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
4622 Fax : +33 1 41 21 46 27