Re: Updatable views
Date: Thu, 08 Dec 2005 20:10:55 +0100
Message-ID: <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
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 - 20:10:55 CET