> > > > > Did anyone test or try Interbase 7? I
> > > >
> > > > It's not available yet.
> > >
> > > It is now, lets all not get too excited about the boolean data type <g>
> >
> > Is that a real boolean type, or is it simply another name for an int?
>
> According to the samples in the paper, you should be able to do:
>
> WHERE booleancolumn = TRUE
>
> So it behaves like a true (*g*) boolean.

Nice ;-), but this reminds me where I have corrected programming
exercises of rather new computer science students, where in some
cases, IF statements looked like:

IF (MYBOOLEAN = TRUE) THEN
MYBOOLEAN := FALSE;
ELSE
MYBOOLEAN := TRUE;
END;

;-)).


So, a boolean column in a WHERE should be evaluated without using
TRUE/FALSE ;-).

Like:

WHERE ID < 1000 AND BOOLEANCOLUMN

or

WHERE ID < 1000 AND NOT BOOLEANCOLUMN

....

The same of course should apply for example for IF statements in
triggers and stored procedures ... ;-).


Thomas.