Hi experts,
I try to read data with an XMLport (Variable Text .csv; but the same problem exists with xml also). I know, the locale the file has been created with (en-US). When I use the XMLport to read the file, the current user's Windows locale on the middle tier server is used for EVALUATE and FORMAT, whether used explicitly or implicitly.
Is there any way to force NAV into using the locale required?
I tried setting the current thread's locales using dotnet, but this did not help. What I did was the equivalent in C/AL to
System.Threading.Thread.CurrentThread.CurrentUICulture = new System.Globalization.CultureInfo("en-US");
System.Threading.Thread.CurrentThread.CurrentCulture = new System.Globalization.CultureInfo("en-US");
The calls appear to succeed. However, WINDOWSLANGUAGE does not change, nor does the behavior of EVALUATE or FORMAT.
GLOBALLANGUAGE is 1033 (ENU) already.