BDS - Genero Migration - SQL and precision

Started by Stephen T., October 25, 2013, 10:40:32 AM

Previous topic - Next topic

Stephen T.

This is akin to the scaling issue.
If something is SUM'd (or presumably any SQL command that performs arithmetic) and the value exceeds the scale (precision) of the target variable, in BDS the code continues and in Genero the program aborts with a precision error.
The problem was noticed on SUMs - hence its use in the example below (I know it's not necessary ;-)).

IE code extract:

DEFINE l_total                                    DEC(8,2)

...
    SELECT SUM(1000*1000) INTO l_total
        FROM some_table

    DISPLAY 'Got Total (',l_total,')'