From: Calin I. P. <pc...@rd...> - 2003-06-30 11:50:09
|
----- Original Message ----- From: "Gabriel Juncu" > You hurried a bit. My first example (and problem) was: > > Param1 = 5655555; > Param2 = 32900; > Result = Param1 * Param2; > > so (56555555 * 10000) * (32900 * 10000) gives 20 digits -> and the > result really overflows ;-) :)) You're absolutely right. I didn't think it through enough. Of course there's always the posibility to write a UDF multiply lib with extended as intermediate type. ;-) As for firebird this is the intended behaviour, and too many rely on it already. Ciao, Best regards, Application Developer Calin Iancu, Pirtea S.C. SoftScape S.R.L. pc...@rd... |