You are viewing limited content. For full access, please sign in.

Question

Question

SQL Stored procedure Error converting data type nvarchar to decimal.

asked on June 11

I am trying to update a SQL database but get this error.

[Microsoft][ODBC SQL Server Driver][SQL Server]Error converting data type nvarchar to decimal.

 

I think it is the "." is being converted to "," in the workflow. I have my regional settings as "." and the language set to english. 

 

I have a token calculator for discount.

When I test the calculation with a "." it works as above.

When I use a "," the test always returns 0.0


When I check the values of the tokens they come in as a "." from the form but change to "," in the work flow. Even with the "," the token is calculated correctly.

 

Thanks

Token.JPG
Token.JPG (42.51 KB)
0 0

Replies

replied on June 11

What version of Workflow are you using? What is the decimal delimiter set in Windows locale settings for the user specified in the service login for the Workflow Server?

0 0
replied on June 11

I am using Workflow Version 10.4.0.131

I am not sure where to find the settings you are asking for for the specified user. 

0 0
You are not allowed to follow up in this post.

Sign in to reply to this post.