Re: Returning SQLCA values: How?

billy@west.co.za (Billy Wheeler) wrote: :> I'm glad that I'm not the only one who thinks that a failed update (due to :> an umatched where caluse) should set an error code. I'm sure that Informix :> have a good reason for not doing so, but I'm not aware of it ;-) :It's an ANSI standard or something equally trivial.... :-) Yes, but the other way arround as far as I remember. If you set your database to ANSI mode I think NOTFOUND will be set in this case, while in standard Informix mode it will not be set as observed. The SQLCA info on the number of rows affected is of course the answer, although it isn't allways easy to get at from non Informix languages. Don't set your database to ANSI mode. You'll get nothing but problems. 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