[FIXED] Decimal point options ?

[ThierryC]

hi,

i have a grid in wich i want to display figures;
this is done by filling up a char zone with editcode 'J'
because in Europe, we mostly use otherr decimal notation (decimal point in europe is ',' and separators for 1000 is '.'
i added the decedit('0,') in my rpg h-specs

by doing this the the form in no longer displayed;
i suspect some conflict with the Json-format ?
possibly to be found in the "totalcount" wich always expects figures with '.' rather that ','

is there a way to solve this ?

[sean.lanktree]

Hi Thierry -

Can you post the JSON response so we can take a look?

[ThierryC]

Without the decimal point option (remark:
]
{"totalCount":.00000,"COWBD20PF":[{"B2SESSID":"B3652A13D0CC9E069BCBEAD1C45D56A6ECABFBFA322194069E B74D26CAC4005E","B2CVERS":"2009RAF1","B2CSITE":"BUD","B2NKLNT":1136,"B2XKLNT":"VALEO VISION BELGE","B2NARTK":20204645,"B2XARTK":"INTERMED. P100/FR1C","B2NBRGR":"0100","B2NBRCM":"0104","B2SARP":"02","B2NTOOL":2046,"B2XTOOL":"INTERMEDIARE GA+DR.FERRARI","B2QTO01":"(351.81)","B2QTO02":".00","B2QTO03":"","B2QTO04":"","B2QTO05":"","B2QTO06":"","B2QTO07":"","B2QTO08":"","B2QTO09":"","B2QTO10":"","B2QTO11":"","B2QTO12":"","B2QTO13":"","B2QTO14":"","B2QTO15":"","B2QTO16":"","B2QTO17":"","B2QTO18":"","B2QTO19":"","B2QTO20":"","B2QTO21":"","B2QTO22":"","B2QTO23":"","B2QTO24":"","B2QVO01":"(225.00)","B2QVO02":".00","B2QVO03":"","B2QVO04":"","B2QVO05":"","B2QVO06":"","B2QVO07":"","B2QVO08":"","B2QVO09":"","B2QVO10":"","B2QVO11":"","B2QVO12":"","B2QVO13":"","B2QVO14":"","B2QVO15":"","B2QVO16":"","B2QVO17":"","B2QVO18":"","B2QVO19":"","B2QVO20":"","B2QVO21":"","B2QVO22":"","B2QVO23":"","B2QVO24":"","B2UPC01":"(1.57242)","B2UPC02":".00000","B2UPC03":"","B2UPC04":"","B2UPC05":"","B2UPC06":"","B2UPC07":"","B2UPC08":"","B2UPC09":"","B2UPC10":"","B2UPC11":"",............


after adding the decedit(',')


{"totalCount":,00000,"COWBD20PF":[{"B2SESSID":"B3652A13D0CC9E069BCBEAD1C45D56A6ECABFBFA322194069E B74D26CAC4005E","B2CVERS":"2009RAF1","B2CSITE":"BUD","B2NKLNT":1136,"B2XKLNT":"VALEO VISION BELGE","B2NARTK":20204645,"B2XARTK":"INTERMED. P100/FR1C","B2NBRGR":"0100","B2NBRCM":"0104","B2SARP":"02","B2NTOOL":2046,"B2XTOOL":"INTERMEDIARE GA+DR.FERRARI","B2QTO01":"(351,81)","B2QTO02":",00","B2QTO03":"","B2QTO04":"","B2QTO05":"","B2QTO06":"","B2QTO07":"","B2QTO08":"","B2QTO09":"","B2QTO10":"","B2QTO11":"","B2QTO12":"","B2QTO13":"","B2QTO14":"","B2QTO15":"","B2QTO16":"","B2QTO17":"","B2QTO18":"","B2QTO19":"","B2QTO20":"","B2QTO21":"","B2QTO22":"","B2QTO23":"","B2QTO24":"","B2QVO01":"(225,00)","B2QVO02":",00","B2QVO03":"","B2QVO04":"","B2QVO05":"","B2QVO06":"","B2QVO07":"","B2QVO08":"","B2QVO09":"","B2QVO10":"","B2QVO11":"","B2QVO12":"","B2QVO13":"","B2QVO14":"","B2QVO15":"","B2QVO16":"","B2QVO17":"","B2QVO18":"","B2QVO19":"","B2QVO20":"","B2QVO21":"","B2QVO22":"","B2QVO23":"","B2QVO24":"","B2UPC01":"(1,57242)","B2UPC02":",00000","B2UPC03":"","B2UPC04":"","B2UPC05":"","B2UPC06":"","B2UPC07":"","B2UPC08":"","B2UPC09":"","B2UPC10":"","B2UPC11":"","B2UPC12":"","B2UPC13":"","B2UPC14":"","B2UPC15":"","B2UPC16":"","B2UPC17":"","B2UPC18":"","B2UPC19":"","B2UPC20":"","B2UPC21":"","B2UPC22":"","B2UPC23":"","B2UPC24":"","B2QPR01":"(0)","B2QPR02":"0","B2QPR03":"","B2QPR04":"","B2QPR05":"","B2QPR06":"","B2QPR07":"","B2QPR08":"","B2QPR09":"","B2QPR10":"","B2QPR11":"","B2QPR12":"","B2QPR13":"","B2QPR14":"","B2QPR15":"","B2QPR16":"","B2QPR17":"","B2QPR18":"","B2QPR19":"","B2QPR20":"","B2QPR21":"","B2QPR22":"","B2QPR23":"","B2QPR24":"","B2UPR01":"(0)","B2UPR02":"0","B2UPR03":"","B2UPR04":"","B2UPR05":"",....................

[sean.lanktree]

Thierry -

In your RPG program, I imagine you have something resembling the following:


vvFormat.embed=TOTALCOUNT+%char(#count);


Change the definition of "#count" (or whatever the name of your variable is) to a non decimal. I assume it is set to a 15,5 now, make it a 10, 0 or whatever you like...as long as there is not a decimal position. The decimal position is not relevant when it comes to a total record count.

Let us know if that works for you.

[ThierryC]

yep, it works

thx