Using 4D v13.5 ... I have a new client in Italy. When he publishes data from his database, the number format gets messed up.
I've set up a little Footrunner script to test it: GET SYSTEM FORMAT(Decimal separator;vDecSep) GET SYSTEM FORMAT(Thousand separator;vThousandSep) fr_NumFormat:="###"+vThousandSep+"###"+vThousandSep+"###"+vDecSep+"##" fr_number:=123456789.99 tMessage:="1: "+String(fr_number)+Char(13) tMessage:=tMessage+"2: "+String(fr_number;fr_NumFormat)+Char(13) AlertMessage (tMessage) -- When I run this on my (UK) system I get the expected result: 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? Thanks! Pat ************************************************* 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] **********************************************************************
