How to use comma (,) as the decimal separator in SQLWindows2005

[Mati Paalmäe]

 Posted by:  Mati Paalmäe 

Hi,

I'm having trouble assigning values to numeric variables (also fetch from
oracle database), when decimal separator in regional setting is set to comma
(,). For example if I declare numeric variable NUM and write statement Set
NUM=2,3, I get syntax error. If I say Set NUM=2.3, it's ok. But when I write
statement Set NUM=SalStrToNumber( '2.3' ) and check cariables value, then
NUM=2,3 (with comma) and it can be used as number. What am I doing wrong,
can anyone help?

Mati

[Krister Henningsson]

 Posted by:  Krister Henningsson 

Hello Mati,

I have Deutsch(Schweiz) for numbers,
currency etc meaning I can't use decimal comma.

When I move my application to a computer with
Schwedish configuration (we use decimal comma)

the same app accepts comma. But, and this is the
funny bit: I can enter a decimal dot number and
copy it to an outher field and it is shown as a decimal
comma number, whereas the app won't accept the
use of decimal comma when mashine is configured for
decimal dot.

Bewildered, Kriss

[wilhelm]

 Posted by:  Wilhelm Speck 

I reported a similat problem a few months ago, but nobody seemed to care.

Wilhelm

[Krister Henningsson]

 Posted by:  Krister Henningsson 

Wilhelm,
oh yes, they care, though not in real time.
They are so o o s p a c e d
only have ing eyes for their stock index
got to focus on what is important see?

Regards, Kriss