Re: Updatable views

"Rick Elbers" <rick.elbers_at_chello.nl> wrote in message news:191hp1p2qvho3j9jsqlk2ugfocqnr7obnk_at_4ax.com...
> Hello Paul,
>
>
> To make it less abstract lets take 1 simple example.
>
> Lets say we have
> Orders, Products, Customers, ProductPrices and OrderDetails and
> we find some way to edit or select all those in 1 gui( thats a
> challenge on itself but a different one). Think about a grid with
> a lot of comboboxes with dropdown style set( so that we can
> add to the combobox too). Now what would be the requirement
> of an updatableView ?

Have you solved the Read Only part of the GUI ?

> It must have the intelligence to determine from the view schema and
> any possible combination of insert/delete/update( which you cant see
> yet in the gui, but its there believe me)the sequence of actions to
> take against any database tables and execute those too.

Have you defined what it means to insert/delete/update in/from/the "view schema" ?

> My question was and is: can somebody prove that this can't be done
> in general or can't be done in certain circumstances ?

The problems are abiguous actions and circular dependencies. Received on Mon Dec 12 2005 - 04:08:07 CST