Subject | Re: [ib-support] arithmetic exception, numeric overflow and string truncation |
---|---|
Author | Ivan Prenosil |
Post date | 2003-04-15T10:40:38Z |
> the query that i am getting exception isPerhaps your QTYONHAND in the table is zero, which lead to dividing by zero:
>
> Update IVITEMLOC
> set QTYONHAND=QTYONHAND+-23.0,
> averagecost = (((23.00000000) +(qtyonhand * averagecost)) / (23.0+
> qtyonhand))
> where ivitemid ='RBDPOLN' and ivlocid =1
> set QTYONHAND= 0 + -23.0,Ivan
> averagecost = (((23.00000000) +(qtyonhand * averagecost)) / (23.0 - 23.0))
http://www.volny.cz/iprenosil/interbase