Re: Stored procs: detecting when SELECT returns no records

Billy Wheeler (bw000001@pixie.co.za) wrote: : Dear Andrew, : As an old and wizend (*not* wise!) programmer, I would INSERT and if the : INSERT failed on a -239 error (Duplicate value in unique key), I would UPDATE. Andrew, You might want to check out Mike Gonzales' new book "Informix Stored Procedures" (or something like that), available from Prentice Hall/Informix Press. Good Luck Joe Lumbley -- --------------------------------------------------------------------------- Joe Lumbley(jlumbley@netcom.com) Dallas, Texas ----------------------------------------------------------------------------