Re: Parametrized query fails

Mike Segel writes: * * Alexander Ponomarenko wrote: * > * > Hi all! * > * > I use Informix OnLine 6.0WF1 with Delphi and have serious problem with * > parametrized queries: * > When I execute something like: * > select * from customers where address = :address, * > and when I assign :address to NULL, Delphi ALWAYS return empty cursor, * > altough there are lots of records where address is NULL. * * Try select * from customers where address is NULL. * Does this work? * (Yeah I know it doesn't answer the question, but it may help find * a solution.) * * -Mikey You can't. You need to change it to: select * from customers where address IS NULL Thanks, ----------------------------------------------------------------------------- Robert Minter Data Systems Support Senior Software Engineer A Client Technologies Company E-Mail: rob@dssmktg.com Tel: 714.771.0454 Fax: 714.771.3028 #include <std_disclaimer.h> http://www.dssny.com