Guten Tag colincoleman2002,

am Dienstag, 5. Mai 2009 um 15:11 schrieben Sie:

> I have reduced to problem we have in our database to a set of
> constants. (for example reasons), normaly this data is retrieved
> from a number of database fields that I have no control over.

> How can I anticipate when this error will occour.

check the definition of your fields and add the precision as show by
sd's reply

> Why do the precisions ADD when i multiply...?

as per sql definition

> What is my solution ?

throw in a couple of

cast( )

into your formulas


--
Mit freundlichen Grüssen
Hannes Streicher mailto:HStreicher@...