I am using TDA to query a JDE database (iSeries unfortunately) over ODBC. Because of the wonderful vaguaries of JDE I am having to divide Quantity and Cost fields by 1000 and 10000 respectively in order to display the ‘true’ value.
Unfortunately I am getting a large number of decimals appearing. Because I am calculating the field, it appears that SQL commands like ROUND will not work, is there any way that I can control this through TDA? I’ve looked at the options but can’t figure out how to get numbers to display to 4 decimal places…
Any advice would be appreciated.