Hi,

> ***********************************************
> Examples of a call that works:
>
> select * from InventoryList(20)

....

>
> ***********************************************
> Examples of calls that don't work:
>
> select * from InventoryList(20) where ItemNum is null
>

...

> ***********************************************

Did you run a fetch-all for both queries?

Regards,
Arno Brinkman
ABVisie

-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Firebird open source database (based on IB-OE) with many SQL-99 features :
http://www.firebirdsql.org
http://www.firebirdsql.info
http://www.fingerbird.de/
http://www.comunidade-firebird.org/

Support list for Interbase and Firebird users :
firebird-support@yahoogroups.com

Nederlandse firebird nieuwsgroep :
news://80.126.130.81



--
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.300 / Virus Database: 265.8.7 - Release Date: 10-2-2005