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

Question

Question

Workflow convert nvarchar value to int

Workflow
Updated July 18, 2014
asked on July 18, 2014

Hi there,

 

We are using Query Data from Workflow to access one external table in a different database, and we are coming to an error saying " Conversion failed when converting the nvarchar value to data type int", is there a way to modify the type of data on workflow???, or to be able to acomplish that i will have to exchange the data type in the database.

 

Best Rergards,

 

Vitor

 

0 1

Answer

SELECTED ANSWER
replied on July 18, 2014

Where is the value coming from? Are you sure it's a number?

0 0

Replies

replied on July 18, 2014

Try using a Custom Query activity and cast the nvarchar to an int.

replied on July 18, 2014

So the value comes from a pattern matting of the field name from laserfiche!, it is not all numbers, one exemplo it will be like this "12345.123456.12345_AAAA-BB", and as the workflow starts , it will take this value, and checks if it find this value in the external database, and if it finds than will be updated.

0 0
replied on July 18, 2014

Hi there,

 

I just find out that the field was wrong!

Thanks Miruna.

 

 

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

Sign in to reply to this post.

Details
Related Posts
Loading ...