I am trying to import data to a datawindow from a tab separated text. The problem is our country's regional settings are set to "," for the sDecimal and "." for the sThousand symbols. When i use the dw_1.importfile we need those settings to be the other way round "." for the sDecimal and "," for the sThousand. If i change those settings from intl.cpl advanced settings and press ok the import works fine. Since i want to automate that procedure so that our users don't have to manually do it i tried doing it by changing the registry values (also tried all combinations of those changes):
RegistrySet("HKEY_CURRENT_USER\Control Panel\International","sDecimal", ".")
RegistrySet("HKEY_CURRENT_USER\Control Panel\International","sThousand", ",")
RegistrySet("HKEY_USERS\Control Panel\International","sDecimal", ".")
RegistrySet("HKEY_USERS\Control Panel\International","sThousand", ",")
The values change just fine, even the window settings in intl.cpl show the new values are inserted BUT when i try to use the dw_1.mportfile the import fails with the exact same behaviour as if the values were set to the original settings. I m not sure if this is a microsoft problem or powerbuilder problem. I tried searching if the windows settings write anywhere else in the registry or in any other file but couldn't find anything with tools like ProcessMonitor and RegShot.
Any help/input would be appreciated.