|Subject||Re: [firebird-support] Re: multiple inserts in trigger|
>> Firdt idea: NULL's usually need to be handled separately becauseThis is new in Firebird 2.0 and isn't available in earlier versions of
>> nothing equals NULL, not even NULL. You may only check for NULL using
>> the "is null" operator.
> Another option for testing null values is to use distinct as in if (value1
> is distinct from value2) then...
> It's only syntactic sugar as they say but it does save a couple of lines...
Firebird. Just in case someone tries that with Firebird 1.x. ;-)
LogManager Series - Logging/Auditing Suites supporting
InterBase, Firebird, Advantage Database, MS SQL Server and