At 07.59 26/11/2001 -0400, you wrote:

>"Marco Lauria" <mslauria@...> wrote in message
>news:5.0.2.1.2.20011126112349.036d0bf8@......
> >
> > I know this, with updatable views I meant the one on which I wrote
>triggers.
> > And every one has a join,
> > I don't need to make a select from view for views with no joins....
>
>Fortunately for you. However, those simple views have a purpose:
>- to filter table columns that users shouldn't access
>- to filter table records that users shouldn't access
>- to ensure that new or modified records meet the WHERE clause (WITH CHECK
>OPTION)
>
>and when you have to use them and need a trigger, problems start.

I know this,
but as my application will work only with a Client GUI Interface I will not
need this
sort of capability.
Also I use views with where clauses and in that case I will not write triggers.