Re: Updatable views
From: x <x_at_not-exists.org>
Date: Tue, 6 Dec 2005 09:37:45 +0200
Message-ID: <dn3f4c$q89$1_at_domitilla.aioe.org>
Date: Tue, 6 Dec 2005 09:37:45 +0200
Message-ID: <dn3f4c$q89$1_at_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 ?
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.
> 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.