Hello Olaf,

[snip]

>> Any chance that one of your values might contain NULL, because a
>> difference check using the comparison operator fails with NULL. You'd
>> better use the IS DISTINCT FROM clause instead of<> for such checks.
>>
>> --
>> With regards,
>>
>> Thomas Steinmaurer
>
> Here Thomas has mentioned already IS DISTINCT FROM ;-)
>
> Cheers
> Christian
>
> Hi there,
>
> I should complete read the renewals of firebird 2! There are much new
> functions integrated, nice features! (I started with firebird 1.5)

Luckily you can read German, thus feel free to get my various articles
in the Entwickler Magazin on the new features in new Firebird releases.

- Firebird 2.0 Teil 1:
http://www.iblogmanager.com/download/misc/articles/2006_01_Firebird_2.0.pdf

- Firebird 2.0 Teil 2:
http://www.iblogmanager.com/download/misc/articles/2007_03_Firebird_2.0b.pdf

- Firebird 2.1
http://www.iblogmanager.com/download/misc/articles/2007_05_Firebird_2.1.pdf

- Firebird 2.5
http://www.iblogmanager.com/download/misc/articles/2010_01_Firebird_2.5.pdf

The most important stuff is covered there. Needless to say, you still
should read the release notes. ;-)

I will also make the article on the new TraceAPI available soon.


HTH.

--
With regards,

Thomas Steinmaurer
Upscene Productions
http://www.upscene.com
http://blog.upscene.com/thomas/

Download LogManager Series, FB TraceManager today!
Continuous Database Monitoring Solutions supporting
Firebird, InterBase, Advantage Database, MS SQL Server
and NexusDB!