"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.

C.
--
Claudio Valderrama C. - http://www.cvalde.com - http://www.firebirdSql.org
Independent developer
Owner of the Interbase® WebRing