Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-01-23 : 09:45:09
|
Minel writes "Hi.
I am having problems calling stored procedures in SQL 7 with currency parameters when my regional settings are set to French.
My system locale was originally English (UK).
The value in UK is £100,300.67
I build up a sql statement and call the recordset open method from Visual Basic 6
Example
rsMain.open "spSavePrice £100300.67"
As you can see VB removes the thousand seperator(,), so as not to confuse SQL Server
But the French representation is
rsMain.open "spSavePrice 100300,67 F"
SQL Server 7 is only expecting one parameter, but "sees" two parameters.
I know already of using the command object and the parameters collection, but this means I have to change alot of code.
Is there a quick way of formatting the currency (also singles/doubles) into a US/UK standard before sending the SQL statement to SQL Server?
Thanx in advance" |
|
|
|
|
|
Problem with passing parameters with locale currency set to French