decimal separator

[elly00]

Hi,
I've a numerica variable like this
a=30.00

I'm doing a sql inser in a field decimal (8,5) using the command insert into..values
The problem is that i should insert that variable as 30,00 leaving the dot as separator SQL doesn't accept value

What can I do?

THANKS

 

[xwb]

1) what is your locale? Is it somewhere in Europe where they use , instead of . in numbers?
2) Do you wish to input the value as 30.00 or 30,00
3) Do you wish to display the value as 30.00 or 30,00
4) Is it VBScript or SQL that is rejecting the number