Re: Is this bad design ?
From: Bob Badour <bbadour_at_golden.net>
Date: Thu, 11 Mar 2004 13:16:05 -0500
Message-ID: <yt2dnQ4g-dO_MM3dRVn-uA_at_golden.net>
Date: Thu, 11 Mar 2004 13:16:05 -0500
Message-ID: <yt2dnQ4g-dO_MM3dRVn-uA_at_golden.net>
"ben brugman" <ben_at_niethier.nl> wrote in message
news:40503104$0$6567$4d4ebb8e_at_read.news.nl.uu.net...
>
> > >
> > > But then the application has to be changed.
> >
> > No, it doesn't. A simple view serves the application well.
> >
> >
>
> If a view is used (I assume a union over both tables),
> how does the application change the data from
> valid to non-valid and vice versa ?
By updating an attribute in the view or in the base table depending on which relvars one decides to make views and which base tables. Received on Thu Mar 11 2004 - 19:16:05 CET