I've modified my test script a bit: // testNumberformatting C_TEXT(tMessage) GET SYSTEM FORMAT(Decimal separator;vDecSep) GET SYSTEM FORMAT(Thousand separator;vThousandSep) fr_NumFormat:="###"+vThousandSep+"###"+vThousandSep+"###"+vThousandSep+"###"+vThousandSep+"###"+vThousandSep+"###"+vDecSep+"00" fr_number:=(Records in table([data_15])*459)/2.3 tMessage:="Numformat: "+fr_NumFormat+Char(13) tMessage:=tMessage+"1: "+String(fr_number)+Char(13) tMessage:=tMessage+"2: "+String(fr_number;fr_NumFormat)+Char(13) AlertMessage (tMessage)
When I run it on my (UK) system I get: Numformat: ###,###,###,###,###,###.00 1: 258237.3913043478387 2: 258,237.39 When my client runs it on his Italian system he gets: Numformat: ###.###.###.###.###.###,00 1: 25983,39130434782783 2: <<<<<<<<<<<<<<<<<<<<<<<<< So the number format string seems to be correct, and the first test is correct, but WHY are we getting all those < in the second test????? Note: - The script is running as a Footrunner script. On the client's machine the database is compiled (but the script isn't). On my machine I've tried it both coupled and uncompiled - makes no difference. HELP!!!! Pat On 20 October 2016 at 20:04, Peter Bozek <[email protected]> wrote: > On Thu, Oct 20, 2016 at 6:17 PM, Pat Bensky <[email protected]> wrote: > > > 1: 123456789.99 > > 2: 123,456,789.99 > > > > When the customer runs it on his Italian system, he gets: > > 1: 12345678999 > > 2: <<< > > > > whereas he should get: > > 1: 123456789,99 > > 2: 123.456.789,99 > > > > ​What am I doing wrong? > > > > Did he opens a method so it retokenizes? If yes, as his system decimal > separator is comma, 123456789.99 is tokenized as 12345678999 - dot is not > recognized as decimal separator. > > Other development environment assume dot is decimal separator whatever is > system setting, 4D not. > > If you send your customer compiled structure, I do not have a clue. > > > -- > > Peter Bozek > ********************************************************************** > 4D Internet Users Group (4D iNUG) > FAQ: http://lists.4d.com/faqnug.html > Archive: http://lists.4d.com/archives.html > Options: http://lists.4d.com/mailman/options/4d_tech > Unsub: mailto:[email protected] > ********************************************************************** > -- ************************************************* CatBase - The Database Publishing Solution tel: +44 (0) 207 118 7889 w: http://www.catbase.com skype: pat.bensky ************************************************* ********************************************************************** 4D Internet Users Group (4D iNUG) FAQ: http://lists.4d.com/faqnug.html Archive: http://lists.4d.com/archives.html Options: http://lists.4d.com/mailman/options/4d_tech Unsub: mailto:[email protected] **********************************************************************
