Updatable views
Date: Mon, 05 Dec 2005 21:25:32 +0100
Message-ID: <3189p1dlv9qpofqai5nq8v32keao7amiph_at_4ax.com>
Dear database experts,
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.
My first try is to find hierarchy in de database by finding the
absolute parents assigning them level 0. Parents of my table are
considered those relations in which my foreign key doesnt allow
DBNull.
Then from there on proceed to give every table that has no parents but
level 0 parents a level 1 etc.
Problems seem to be autojoins and multiple relations between tables. Those problem can be solved to use every table only once in the scan.
So the first question is: will this way of hierarchising the relational db always valid ?
Regards and tx for answering,
Rick Elbers
Received on Mon Dec 05 2005 - 21:25:32 CET