JParente
asked on
SQL String
Hi,
I need to add lines to a table using the SQL instruction (e.g.) "INSERT INTO table (Customer, Cost) VALUES ('Company', 235,35)" Where 235,25 is the total amount for this company, for instance.
The problem is that in regional definitions i've set the comma (,) as the decimal simbol because i need that way to other apps and i can't change it and the VB generates an error because we have 2 fileds and 3 values. Of course the 235,35 is 235 units and 35 decimals.how can i handle this problem without changing Regional settings?
I need to add lines to a table using the SQL instruction (e.g.) "INSERT INTO table (Customer, Cost) VALUES ('Company', 235,35)" Where 235,25 is the total amount for this company, for instance.
The problem is that in regional definitions i've set the comma (,) as the decimal simbol because i need that way to other apps and i can't change it and the VB generates an error because we have 2 fileds and 3 values. Of course the 235,35 is 235 units and 35 decimals.how can i handle this problem without changing Regional settings?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
You are welcome,
Good Luck,
Ameen.
-------------------------- ------
Need cheap and reliable web hosting? Check out unlimitedhostingplans.com, sign up now and win a X-box!
Good Luck,
Ameen.
--------------------------
Need cheap and reliable web hosting? Check out unlimitedhostingplans.com,
BTW if you use a decimal 235.35, then SQL Server/ADO Provider will convert for any locality anyway...
ASKER
Works fine, thanks!