Hi Ivan

yes my QTYONHAND value is 0.0000

but before i do the divide operation i am adding QTYONHAND to 23.000 , there
is (23.0+ qtyonhand).
is this also gives the divide by zero exception.

Thanks
Usha

----- Original Message -----
From: "Ivan Prenosil" <prenosil@...>
To: <ib-support@yahoogroups.com>
Sent: Tuesday, April 15, 2003 6:40 PM
Subject: Re: [ib-support] arithmetic exception, numeric overflow and string
truncation


> > the query that i am getting exception is
> >
> > Update IVITEMLOC
> > set QTYONHAND=QTYONHAND+-23.0,
> > averagecost = (((23.00000000) +(qtyonhand * averagecost)) / (23.0+
> > qtyonhand))
> > where ivitemid ='RBDPOLN' and ivlocid =1
>
> Perhaps your QTYONHAND in the table is zero, which lead to dividing by
zero:
>
> > set QTYONHAND= 0 + -23.0,
> > averagecost = (((23.00000000) +(qtyonhand * averagecost)) / (23.0 -
23.0))
>
>
> Ivan
> http://www.volny.cz/iprenosil/interbase
>
>
>
>
>
>
>
> To unsubscribe from this group, send an email to:
> ib-support-unsubscribe@egroups.com
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>