Re: Select NULL column in Java

billy@west.co.za ("Billy Wheeler") wrote: :On 6 Aug 97 at 8:42, Nils Myklebust wrote: : :> In JDBC there is a method to test for null. Sun has realy bungled :> this one though. You have to use a getXXX method to read a column :> value into a variable before you can test for null. Therefore it's :> called wasNull (not isNull). You also are supposed to use the getXXX :> method only once for each row and do it in a right to left order as :> in the select statement. Realy utterly stupid, [snip] : :Boy, and some people have the temerity to complain about NewEra... For the benefit of someone in South Africa (and others) i forgot to mention that you should of course structure your application and/or use tools that minimizes or removes the rigmarole explained here. We are testing DDJ now. It even has the NewEra SuperTables...??? 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