Re: Updatable views

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 ?

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.

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

Hope this helps the discussion,

Rick  

On Thu, 08 Dec 2005 04:30:55 GMT, paul c <toledobythesea_at_oohay.ac> wrote:

>-CELKO- wrote:
>> Once you have a join in a VIEW it cannot be updated directly; you will
>> need to use INSTEAD OF triggers.
>>
>
>
>Not everybody here is talking about SQL. I believe there is a usenet
>group for that.
>
>Just because some big-ticket products don't bother implementing the
>updates that are possible, is no reason for such a blanket statement.
>
>Cheers,
>p
Received on Thu Dec 08 2005 - 13:10:55 CST