chris
Jul 13, 2010 2:05:22 AM

where can i set the decimal separator - comma

hy, I have the new version of winsql installed. I cant find the option where to set the decimal separator. The system settings are not recognized by winsql. in the result i get for a numeric value: 124324.45 i need: 124324,45 In the old version (7.?) i didnt have this problem regards chris


Jack
Jul 14, 2010 9:37:10 AM

where can i set the decimal separator - comma

Chris, Check http://web.synametrics.com/oracommasep.htm if you are using Oracle. If not Oracle, then check the ODBC DSN settings. It is the ODBC driver that converts dates into Strings, which then gets displayed in WinSQL as-is. Jack. >hy, > >I have the new version of winsql installed. >I cant find the option where to set the decimal separator. >The system settings are not recognized by winsql. > >in the result i get for a numeric value: 124324.45 >i need: 124324,45 > >In the old version (7.?) i didnt have this problem > >regards chris


chris
Jul 15, 2010 2:01:13 AM

where can i set the decimal separator - comma

Hy, thank you - the setting in the ODBC Manager helped me. Chris >Chris, > >Check http://web.synametrics.com/oracommasep.htm if you are using Oracle. > >If not Oracle, then check the ODBC DSN settings. It is the ODBC driver that converts >dates into Strings, which then gets displayed in WinSQL as-is. > >Jack. > >>hy, >> >>I have the new version of winsql installed. >>I cant find the option where to set the decimal separator. >>The system settings are not recognized by winsql. >> >>in the result i get for a numeric value: 124324.45 >>i need: 124324,45 >> >>In the old version (7.?) i didnt have this problem >> >>regards chris

Navigation

Social Media

Powered by 10MinutesWeb.com