Re: Parametrized query fails

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