Re: Divide by zero

Posted in 1996

Jake Salomon — Mon, 18 Nov 1996 23:39:08 -0500 — source: Informix-list mailing list archive (1991-1998)

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 Paul Roberts wrote: > > In article <558kgp$mac@cssun.mathcs.emory.edu>, > William Knott <knottw@cork.cig.mot.com> wrote: .... > >I've run into the divide by zero problem when calculating equations in the > >database. > > > >The equations are akin to (a + b) / (c + d) > >or > >[ a + (b /c) ] / (d + e) > >where c and d can be minus numbers. > > Well, you could always do something like:- ... Omitted