Re: Updatable views

From: x <x_at_not-exists.org>
Date: Tue, 6 Dec 2005 09:37:45 +0200
Message-ID: <dn3f4c$q89$1@domitilla.aioe.org>

"Rick Elbers" <rick.elbers_at_chello.nl> wrote in message news:3189p1dlv9qpofqai5nq8v32keao7amiph_at_4ax.com...

> Can somebody enumerate the problems with an updatable view for me ?
> With an updatebleview:= joined set of related tables and relations
> from which rows can be updated, inserted and deleted like you
> can in a simple table or master-detail relation.

Try your algorithm with 0, 1 , 2 , 3 , 4 tables with columns of identical type (numeric or char(n) for example) and various unique and referential constraints.

Try to update/insert/delete a join of 2 tables and see what happen. Received on Tue Dec 06 2005 - 01:37:45 CST