Hi Claudio,

> The reason isql doesn't get confused is that it never looks at those
> triggers! Remember they are an implementation detail. By looking at the
> source of the view, you know that WITH CHECK OPTION was used (old IB
> versions write only WITH CHECK in the view's source, be careful) so the
> check trigger is useless for you. However, the engine should care and

since

I've just created a view with the WITH CHECK OPTION clause in FB, RC2
and it seems to write WITH CHECK to the view's source - leaving out the
OPTION part... IB 6.5 too, btw...

Can you confirm this?

Martijn Tonies
InterBase Workbench - the developer tool for InterBase and Firebird
http://www.interbaseworkbench.com

Upscene Productions
http://www.upscene.com

"This is an object-oriented system.
If we change anything, the users object."