Re: Inserting through a view - forcing certain values into columns

In article <1173715114.347907_at_bubbleator.drizzle.com>, DA Morgan says...
> Jeremy wrote:
> > In article <55ku75F25p4g8U1_at_mid.individual.net>, Serge Rielau says...
> >> WITH CHECK OPTION;
> >>
> >
> > Thanks Serge, I should have been able to recall that.
>
> What has been suggested to you will not allow values other than "Y"
> but will not change an "N" to a "Y".

Thanks - it raises an exception if you try to supply a value other than 'Y' which is OK for the present needs.
>
> If you want to override what has been entered use an INSTEAD OF trigger.
>

Thanks.

-- 
jeremy