Re: Updatable views

"Rick Elbers" <rick.elbers_at_chello.nl> wrote in message news:2pmbp1hqpqim6lceqg57sdjgh7vkcsg49p_at_4ax.com...

> Trail and Error ?

This is the only way to really learn. No amount of reading substitute trial and error.

> It seems like you know the answer. Or is it that it only seems so ?

Maybe. Maybe not. I wouldn't really know until I really try.

> 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
If this works for all the cases with 0,1,2,3,4 tables then I think it will work in the general case. Received on Wed Dec 07 2005 - 09:10:45 CET