Question

SQL Stored procedure Error converting data type nvarchar to decimal.

Workflow

Updated May 8, 2023

asked on June 11, 2019

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 (42.51 KB)

| Download

0 0

Replies

replied on June 11, 2019

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, 2019

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

replied on August 17, 2021

Have you managed to resolve this?

I am currently having the same issue and dont know how to resolve it

Regards, AQ

0 0

replied on May 8, 2023

This appears to occur on some of our workflows if the number is empty as well.

0 0

You are not allowed to follow up in this post.

Question

Question

SQL Stored procedure Error converting data type nvarchar to decimal.

Replies

Sign in to reply to this post.