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

Question

Question

convert nvarchar value to tinyint?

Workflow
Updated April 28
asked on April 25

I have a form that feeds a workflow, the field is called Numbers (verified it was text), but it can occasionally be letters. I get this error when I try to add a new row to a database.

0 0

Answer

SELECTED ANSWER
replied on April 25

This is a database issue, not a Laserfiche issue. If "MF" truly does sometimes contain text characters (and should contain text characters), why would your database column be a tinyint column? Alter your table to have the correct data type. If "MF" isn't supposed to contain text characters, change the form  field to validate using regex for numbers only or replace the field with a number field.

2 0
replied on April 28

I ended up working around the issue, but will discuss with IT. 

Thanks for the info.

0 0

Replies

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

Sign in to reply to this post.

Details
Related Posts
Loading ...