Subject | Rounding erros in calculated columns ? |
---|---|
Author | Carlos H. Cantu |
Post date | 2001-07-02T11:29:49Z |
An user reported this to me... anybody knows something about it ? Is it a
bug ? :
I have a calculated column :
NEW.TOTAL= NEW.A + NEW.B - NEW.C
A,B and C are Numeric(15,2)
* Sometimes * the result is wrong, like :
Ex. A=9.82 , B=0 e C=0 => Total= 10.00
* Sometimes * if I update the record the total value is corrected.
[]s
Carlos
WarmBoot Informatica - http://www.warmboot.com.br
Interbase-BR - http://www.interbase-br.com
AWH> At 10:34 AM 6/28/2001 +0100, Ian Newby wrote:
AWH> or faster, particularly when you want to do something like modulo
AWH> that is an operator in C and a pain in the ... in stored procedure
AWH> language. You have the one time cost of loading the dll library,
AWH> but the linkage is quite simple and quick.
AWH> Regards,
AWH> Ann
AWH> www.ibphoenix.com
AWH> We have answers.
AWH> To unsubscribe from this group, send an email to:
AWH> ib-support-unsubscribe@egroups.com
AWH> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
bug ? :
I have a calculated column :
NEW.TOTAL= NEW.A + NEW.B - NEW.C
A,B and C are Numeric(15,2)
* Sometimes * the result is wrong, like :
Ex. A=9.82 , B=0 e C=0 => Total= 10.00
* Sometimes * if I update the record the total value is corrected.
[]s
Carlos
WarmBoot Informatica - http://www.warmboot.com.br
Interbase-BR - http://www.interbase-br.com
AWH> At 10:34 AM 6/28/2001 +0100, Ian Newby wrote:
>> Has anyone any information on the relative speed of UDF's versesAWH> For operations that don't require data access, UDFs are as fast
>>stored procedures? Which one would be best in this instance.
AWH> or faster, particularly when you want to do something like modulo
AWH> that is an operator in C and a pain in the ... in stored procedure
AWH> language. You have the one time cost of loading the dll library,
AWH> but the linkage is quite simple and quick.
AWH> Regards,
AWH> Ann
AWH> www.ibphoenix.com
AWH> We have answers.
AWH> To unsubscribe from this group, send an email to:
AWH> ib-support-unsubscribe@egroups.com
AWH> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/