Re: Returning SQLCA values: How?

Posted in 1996

Pkjones0 — 28 Sep 1996 09:27:51 -0400 — source: Informix-list mailing list archive (1991-1998)

In article <324C7D48.2C09@wwa.com>, M Ferris <mferris@wwa.com> writes: >I have several stored procedures that do an update on a table, such >as: > >update mytable >set myfield = myvariable >where mykeyfield = passed_arg. > >End procedure > >If no rows are found to match my argument, this is not considered an >error, but shouldn't SQLCA.SQLCode be = 100? 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 ;-) Pete