Named Query parameter datatype

Ignition
1

Hi,

Why is ignition generating queries with parameter as nvarchar(4000) even though i selected int4 in the designer?

(@P0 nvarchar(4000))SELECT SAPNO from RECIPE_MAIN where PRODUCTNO = @P0

image
image1357×206 5.25 KB

2

could it be the datatype for the table column?

3

Is an int in MSSQL so I don't think that is the issue.

Thank you