Re: Informix for NT

"Adrian SIMO" <Adrian.Simo@swh.sk> wrote: :Hi all! :I'm looking for someone with experiences running any client :application against Informix OnLine Workgroup Server 7.13 through Informix :router and Informix-NET 5.01 :We have following problem: :If we have a SQL command like :SELECT * FROM table :WHERE : col1 = :BindVar1 AND : col2 = :BindVar2 AND : col3 = :BindVar3; :where BindVar1, BindVar2 and BindVar3 become in runtime equal NULL the DB :server falls down without any error message. Is there any way to go by :(other than testing all BindVars before executing SQL command) ? Do you mean to say that the database is actually crashing? The log messages would be interesting. Or are there non even in the Informix log? However you still have to test the BindVar?'s for NULL. This statement will return nothing if any one of them are NULL. You have to change your statement to colx is null if you actually want rows returned where this is the case. If you want no rows in this case your statement is ok, but you also don't need to execute it so you would want to test anyway. Whatever you want, the database should of course not crash on such a statement (or any statement for that matter). :I use as client software Gupta - SQL Windows and I can't determine, where :on which side is problem Informix or Gupta. Any suggestions ? Nils.Myklebust@idg.no NM Data AS, P.O.Box 9090 Gronland, N-0133 Oslo, Norway My opinions are those of my company The Informix FAQ is at http://www.iiug.org