Quote

>"Jedi Knight Disco Mike" <DiscoM...@Hotmail.Com> wrote
>> I am using calculated fields on a Query Table within Delphi 5 Pro.
>> Within the calculated fields, I get NAN fields when I really want
>> displayed is the number Zero on divisible calculations.

>I don't understand.  Are you allowing your code to attempt division
>by zero?  If so, why not just check for division before the divide?

>> I have used a try on EDivByZero and EZeroDivide to try to catch
>> the error.  Ideally, when this error happens, I want the field to say
>> Zero,

>Do you mean that you want to set the result to zero on exceptions?

>> but whichever Exception Error I use, I still see a NAN displayed
>> instead of Zero.  The two numbers I am trying to divide
>> (numerator and denominator) are both integer numbers.
>> The resulting variable is of a real type.

>> The resulting variable can be changed to single, double or extended
>> if it would help alleviate this NAN error I keep getting.

>From basic algebra, a divide by zero does not give a valid number,
>you must handle it before you do the divide or catch it after the divide
>attempt.

>Unless somebody's code has been tampering with the FPU control
>word, any attempt to divide by zero should give an exception.  Does
>it?

>> Also, when doing calculations in queries, how does Delphi handle
>> calculations when a field is blank ?
>> Is Delphi smart enough to assume that the blank field(s) is zero ...

>It may very well assume that a blank field is zero,
>but I would not call that *smart*.  It can lead to problems.
>Regards, JohnH