Division through Zero 0/0

daroon
daroon Member Posts: 35
edited 2002-04-12 in Navision Financials
Hi,

on request form of a report i had to put in some numbers, like a = 10 b = 5. now in code i had to calculate

c := a / b;

But when the peeps put in zeros for a or for b Navision had a division through Zero. Is there another way then:

if (a <> 0) OR (b <> 0) Then begin
c := a /b
end else
c := 0;

They had to put over 20 numbers into the request form, and i dont wanna code 20 times these lines, does anyone know a better way ??

Thank you for helpin me ( and reading my GOOD English <img border="0" title="" alt="[Smile]" src="images/smiles/icon_smile.gif" /> ) )

Ronnie

Comments

  • Toni_Lou
    Toni_Lou Member Posts: 11
    The most obvious way would be to write a function to do what you want:
    ______________

    DivideWithCaution(decimal P_a, decimal P_b): decimal L_result

    IF (P_b <> 0) THEN
    exit(P_a / P_b);

    exit(0);

    ______________

    and call that function wherever you want.

    Toni
  • Luc_VanDyck
    Luc_VanDyck Member, Moderator, Administrator Posts: 3,633
    Use the MinValue and MaxValue properties on the fields of the form. This will prevent the users from entering 0 (at least if the MinValue is set to 1).
    No support using PM or e-mail - Please use this forum. BC TechDays 2024: 13 & 14 June 2024, Antwerp (Belgium)
  • daroon
    daroon Member Posts: 35
    Thanx for helping me, will check it with the function.

    Mynavision RULEZ <img border="0" title="" alt="[Smile]" src="images/smiles/icon_smile.gif" />

Categories