Re: Divide by zero

Posted in 1996

David Williams — Wed, 20 Nov 1996 00:53:32 +0000 — source: Informix-list mailing list archive (1991-1998)

In article <329139EC.272A@sprynet.com>, Jake Salomon <jsalomon@sprynet.com> writes >Paul & Company, > >I recently called in a bug (or at least an unexpected quirk) in 4GL >(6.01). > >I was getting unexpected nulls as a result of calculation. Very >strange, having shown than none of the numbers involved were NULL. I >discovered that if you divide by 0 integers, (I think DECIMAL as well) >you get a null result instead of the kick-out you ought to get. > >I haven't tried this with an SQL statement. > > -- Jake > You need to use either WHENEVER ANYERROR STOP or compile with c4gl -anyerr ... Check your release notes in $INFORMIXDIR/release/4GL* -- David Williams