Websydian v6.1 online documentationOnline documentation - Websydian v6.1

Problem - Formatting numeric fields using comma fails on iSeries

Product Websydian Web Developer
Version Websydian 2.5, 3.0, 3.1, 4.0, 4.01, 5.5, 5.5SP1
Resolved in v6.0
Platform iSeries
Category Formatting Output
Question Using Plex 5.0 and iSeries as the database and webserver the formatting of numeric fields is incorrect when using comma as decimal separator.
Answer The problem is related to the way Plex casts character fields to numeric fields.

Using Plex 4.0 and prior the cast always assumed that dot (.) represented the thousand separator.

Using Plex 5.0 and later the cast argument checks the local settings of the iSeries OS/400, which results in using comma (,) as thousand separator when using European settings of the iSeries.

Workaround To fix this insert the following statement in the pre point '0 Date/time formatting' in the abstract event handler function.

Set Local<DecimalSeparatorCast> = <DecimalSeparatorCast.Thousandseparator>