Subject Re: [Firebird-Architect] FB 2.0 Road Map
Author Daniel Rail
Hello Martijn,

Thursday, September 9, 2004, 1:49:17 PM, you wrote:

> Hi Dmitry,

>> ABS> If (
>> ABS> (Old.Quantity <> New.Quantity) or
>> ABS> ((Old.Quantity is null) and (New.Quantity is not null)) or
>> ABS> ((Old.Quantity is not null) and (New.Quantity is null))
>> ABS> ) then
>> Yaffil supports MS SQL-style == operator, i.e. yours code
>> can be changed to

> Where do you find == in MS SQL BOL? I cannot find it.

You're not the only one. I can't either. I did find a reference in
regards to the equals operand, for those who would like to see how
it's handled:

[Start quote...]
Compares two expressions (a comparison operator). When you compare
nonnull expressions, the result is TRUE if both operands are equal;
otherwise, the result is FALSE. If either or both operands are NULL
and SET ANSI_NULLS is set to ON, the result is NULL. If SET ANSI_NULLS
is set to OFF, the result is FALSE if one of the operands is NULL, and
TRUE if both operands are NULL.
[...End quote]

But, I can see "==" implemented in FB as the equivalent of MS-SQL's
combination of SET ANSI_NULLS OFF and the equal(=) operand. Basically,
a non-ANSI(NULL) compliant equal.

Best regards,
Daniel Rail
Senior Software Developer
ACCRA Group Inc. (
ACCRA Med Software Inc. (