Re: Returning SQLCA values: How?

Nils Myklebust wrote: > > 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.... :-) Time to play devil's advocate : Surely this is a subjective issue, your where clause could be including or excluding rows, so if I run a regular update to fix junk data and it finds 0 rows, that is the desired result i.e there is no junk data, therefore in this instance a success. I think informix's approach (set sqlca.sqlerrd[2|3]) is the right one) -- Steve Weet steve@weet.demon.co.uk Ensigndata Ltd Office: +44 01634 577054 Informix and Tetra consultancy Mobile: +44 0468 301927 and programming services