Re: Updatable views

From: Rick Elbers <rick.elbers_at_chello.nl>
Date: Tue, 06 Dec 2005 19:41:44 +0100
Message-ID: <2pmbp1hqpqim6lceqg57sdjgh7vkcsg49p_at_4ax.com>


Trail and Error ?
It seems like you know the answer. Or is it that it only seems so ?

Rick

On Tue, 6 Dec 2005 09:37:45 +0200, "x" <x_at_not-exists.org> wrote:

>
>"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.
>

I know that it works for simple cases, otherwise I wouldnt ask Received on Tue Dec 06 2005 - 19:41:44 CET

Original text of this message