At 03:16 PM 30-04-01 +0200, you wrote:

>Helen,
>
> > The reason for this is a bug in IB6 that returns null for select count(*)
> > if no rows are found (it ought to return zero).
>
>this scares me. Any additional info on that bug (the only thing I know
>for now is I can't reproduce it)?

It's in the Firebird buglist. It applied to the binaries downloaded from the Borland website but I *think* it got fixed in Firebird some time ago. About the new Borland binaries, I do not know. If you post a question in Firebird-devel, you will probably get an answer from the programmer who did the fix...

BTW, does anyone happen to have a reference about the initialization of

>variables in triggers and stored procedures? Are they automatically
>initialized or not? I suspect not, but haven't found a piece of
>documentation that clearly states it yet.

No documentation that I can find...but they are not automatically initialised. You also have to watch out for input arguments that you refer to as variables and make sure you test for null before testing for equivalence or (in the case of concatenation) before appending to them, unless you are very certain that your application has eliminated the possibility of despatching a NULL argument.

Cheers,
H.

All for Open and Open for All
InterBase Developer Initiative · http://www.interbase2000.org
_______________________________________________________