# Named Query parameter datatype

**URL:** <https://forum.inductiveautomation.com/t/named-query-parameter-datatype/115694>\
**Category:** Ignition\
**Tags:** namedqueries\
**Created:** [May 26, 2026, 1:02am UTC](https://forum.inductiveautomation.com/t/named-query-parameter-datatype/115694 "2026-05-26T01:02:52Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![rickard.eriksson](https://avatars.discourse-cdn.com/v4/letter/r/7cd45c/32.png) [@rickard.eriksson](https://forum.inductiveautomation.com/u/rickard.eriksson)\
**Post date:** [May 26, 2026, 1:02am UTC](https://forum.inductiveautomation.com/t/named-query-parameter-datatype/115694/1 "2026-05-26T01:02:52Z")

</div>

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](https://us1.discourse-cdn.com/inductiveautomation/original/3X/5/8/584ece470159143af0870369282f863e1aca923f.png)

---

<div class="post-metadata">

**Author:** ![Jasmine\_Quick](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/jasmine_quick/32/80380_2.png) [@Jasmine\_Quick](https://forum.inductiveautomation.com/u/Jasmine_Quick)\
**Post date:** [May 26, 2026, 1:10am UTC](https://forum.inductiveautomation.com/t/named-query-parameter-datatype/115694/2 "2026-05-26T01:10:00Z")

</div>

could it be the datatype for the table column?

---

<div class="post-metadata">

**Author:** ![rickard.eriksson](https://avatars.discourse-cdn.com/v4/letter/r/7cd45c/32.png) [@rickard.eriksson](https://forum.inductiveautomation.com/u/rickard.eriksson)\
**Post date:** [May 26, 2026, 1:10am UTC](https://forum.inductiveautomation.com/t/named-query-parameter-datatype/115694/3 "2026-05-26T01:10:42Z")

</div>

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

Thank you

---

<div class="post-metadata">

**Author:** ![Lynn\_Martineau](https://avatars.discourse-cdn.com/v4/letter/l/f1d935/32.png) [@Lynn\_Martineau](https://forum.inductiveautomation.com/u/Lynn_Martineau)\
**Post date:** [May 26, 2026, 8:19pm UTC](https://forum.inductiveautomation.com/t/named-query-parameter-datatype/115694/4 "2026-05-26T20:19:25Z")

</div>

How are you calling this function?

If you just want a SELECT, try [system.db.runPrepQuery | Ignition User Manual](https://www.docs.inductiveautomation.com/docs/8.3/appendix/scripting-functions/system-db/system-db-runPrepQuery)  
or, a better option might be using a Named Query with [system.db.execQuery | Ignition User Manual](https://www.docs.inductiveautomation.com/docs/8.3/appendix/scripting-functions/system-db/system-db-execQuery) or [system.db.runScalarPrepQuery | Ignition User Manual](https://www.docs.inductiveautomation.com/docs/8.3/appendix/scripting-functions/system-db/system-db-runScalarPrepQuery)