Decimal Precision problem?

[rcalaby]

Guys,

I have a Project setup with multiple operations performing calculations and roll-ups to and from a temp MySQL db.

One calculation reported by our customer looses 3 cents, so on digging into this and using the [WriteToOperationLog] function, I was able to show the calculation result inside Jitterbit and retrieve the SQL being used to gain this result.

When in Jitterbit the result = 10730
When using the same generated SQL from Jitterbit to get the above figure within MySQL, the result = 10730.03
(note the missing 3 cents)

The generated SQL looks similar to the following: [SELECT SUM(amount) FROM tbl_Rolled_Up_Values WHERE {conditions};]

I have tried to cast it to a Float in Jitterbit with the same result.... no decimals {lost 3 cents}

Have been using the [MySQL ODBC 5.1 Driver [ODBC]] driver through-out this project so far without any problems.

Can you assist or point out what is wrong?

Thanks,
Russ

[emanuel]

Hi,

there is a problem with the old implementation of ODBC lookups (DbExecute and Dblookup using an ODBC driver). Use the new implementation by setting

UseOldDbLookup=true

under the [TransformationEngine] section of jitterbit.conf or use a JDBC driver instead.

/Cheers
Emanuel