Hi,

> > I have a database on IB 6.0.2 and created a view with the WITH CHECK
> OPTION
> > clause. I noticed appearing two triggers, obviously
> checking the clause :)
> >
> > When I did the same yesterday on IB 6.5, these triggers
> didn't appear as
> > 'normal' triggers, but had a RDB$SYSTEM_FLAG value of 5 (VIEW CHECK
> OPTION).
> > IB 6.0.2 doesn't know this type in RDB$TYPES.
> >
> > FB RC2 restored the database with the two 'normal'
> triggers. Dropping the
> > view and re-creating it created the two triggers with type
> 5 - is this one
> > of the bugfixes for FB and taken into IB 6.5?
>
> Please double check which engine you used. :-)
> I wasn't aware that IB6.5 would do the same than Firebird.
> Hope you really ran the IB6.5 executable.

Ugh, Claudio - seems you're right after all ... IB still has the nasty
check trigger thingy...


pfff, putting my changes back in :(

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