Problem in aggregating decimal value
Posted: Fri Apr 07, 2006 1:07 am
Hi all.
I am doing sum of columns decimal(15,2) But i am getting warning
AG_GLData,0: APT_Decimal::operator=: the source decimal has even precision, but non-zero in the leading nybble, or is too large for the destination decimal.
For that i have tried changing target length to decimal(17,2) also decimal(19,4).But this doesn't worked.It looks as if there is problem in putting the decimal value in target field after all processing as it is fixed width field.So what should i do for that case.
I am doing sum of columns decimal(15,2) But i am getting warning
AG_GLData,0: APT_Decimal::operator=: the source decimal has even precision, but non-zero in the leading nybble, or is too large for the destination decimal.
For that i have tried changing target length to decimal(17,2) also decimal(19,4).But this doesn't worked.It looks as if there is problem in putting the decimal value in target field after all processing as it is fixed width field.So what should i do for that case.