# INSERT query show error

**URL:** <https://forum.inductiveautomation.com/t/insert-query-show-error/110566>\
**Category:** Ignition\
**Tags:** perspective\
**Created:** [September 12, 2025, 8:29am UTC](https://forum.inductiveautomation.com/t/insert-query-show-error/110566 "2025-09-12T08:29:09Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![TechEnlive](https://avatars.discourse-cdn.com/v4/letter/t/3be4f8/32.png) [@TechEnlive](https://forum.inductiveautomation.com/u/TechEnlive)\
**Post date:** [September 12, 2025, 8:29am UTC](https://forum.inductiveautomation.com/t/insert-query-show-error/110566/1 "2025-09-12T08:29:09Z")

</div>

Hi,

We have an **INSERT** query, and after executing it, we try to refresh the table data. However, the **INSERT** query always shows an error, even though the new record is successfully added to the table. Because of this error, the subsequent code does not execute.

```python
# If both not found, insert new record
		if not userExists and not badgeExists:
		    system.db.runNamedQuery(
		        "gestione_produzione/SystemMgmt/InsertOperatorUser",
		        {
		            "USER": userValue,
		            "FIRSTNAME": firstName,
		            "LASTNAME": lastName,
		            "BADGECODE": badgeValue,
		            "CREATEDDATETIME": system.date.now(),
		            "ACTIVE": True,
		            "LASTLOGIN":system.date.now(),
		            "MODIFIEDDATETIME":system.date.now()
		        }
		    )
		    
		    msg = "Il record inserito"
		    iconPath = "material/warning"
		    # Open popup
		    system.perspective.openPopup(
				"BP_PopupConfirm_operator",
				view="templates/PopupInfo",
				params={
					"message": msg,
					"icon": iconPath					
				},
				title="Conferma",
				modal=True,
				draggable=False,
				resizable=False,
				showCloseIcon=True
			)		    
		    table = self.parent.parent.getChild("Table_0")		    
		    table.refreshBinding("props.data")

```

The error return by insert query is this:

```python
Error running action 'component.onActionPerformed' on pages/Operator_mgmt@D/root/FlexContainer_1/FlexContainer/Button: Traceback (most recent call last): File "<function:runAction>", line 32, in runAction at com.inductiveautomation.ignition.gateway.db.namedquery.NamedQueryExecutor$NamedQueryInstance.execute(NamedQueryExecutor.java:407) at com.inductiveautomation.ignition.gateway.db.namedquery.NamedQueryExecutor.execute(NamedQueryExecutor.java:173) at com.inductiveautomation.ignition.gateway.db.namedquery.GatewayNamedQueryManager.execute(GatewayNamedQueryManager.java:95) at com.inductiveautomation.ignition.common.db.namedquery.SecuredNamedQueryManager.execute(SecuredNamedQueryManager.java:78) at com.inductiveautomation.ignition.gateway.script.GatewayDBUtilities.runNamedQuery(GatewayDBUtilities.java:419) at jdk.internal.reflect.GeneratedMethodAccessor24.invoke(Unknown Source) at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.base/java.lang.reflect.Method.invoke(Unknown Source) java.lang.Exception: java.lang.Exception: com.microsoft.sqlserver.jdbc.SQLServerException: The statement did not return a result set.

```

---

<div class="post-metadata">

**Author:** ![Transistor](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/transistor/32/3380_2.png) [@Transistor](https://forum.inductiveautomation.com/u/Transistor)\
**Post date:** [September 12, 2025, 8:39am UTC](https://forum.inductiveautomation.com/t/insert-query-show-error/110566/2 "2025-09-12T08:39:02Z")

</div>

What is the code in the button?  
`/root/FlexContainer_1/FlexContainer/Button:`

`File "<function:runAction>", line 32,`  
What's on line 32?

`SQLServerException: The statement did not return a result set.`  
Are you looking for a result set?

---

<div class="post-metadata">

**Author:** ![pascal.fragnoud](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pascal.fragnoud/32/24728_2.png) [@pascal.fragnoud](https://forum.inductiveautomation.com/u/pascal.fragnoud)\
**Post date:** [September 12, 2025, 8:41am UTC](https://forum.inductiveautomation.com/t/insert-query-show-error/110566/3 "2025-09-12T08:41:45Z")

</div>

Change the query type of your named query to `update`

 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/7/7/778994394cff36cecc72864a1c9da98b08c52e51.png)

---

<div class="post-metadata">

**Author:** ![TechEnlive](https://avatars.discourse-cdn.com/v4/letter/t/3be4f8/32.png) [@TechEnlive](https://forum.inductiveautomation.com/u/TechEnlive)\
**Post date:** [September 12, 2025, 8:43am UTC](https://forum.inductiveautomation.com/t/insert-query-show-error/110566/4 "2025-09-12T08:43:47Z")

</div>

Thanks a lot you all of you for quick support…

---

<div class="post-metadata">

**Author:** ![Transistor](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/transistor/32/3380_2.png) [@Transistor](https://forum.inductiveautomation.com/u/Transistor)\
**Post date:** [September 12, 2025, 10:30am UTC](https://forum.inductiveautomation.com/t/insert-query-show-error/110566/5 "2025-09-12T10:30:13Z")

</div>

Hi, Pascal.  
What was the clue in the error message that I missed?

---

<div class="post-metadata">

**Author:** ![pturmel](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pturmel/32/3295_2.png) [@pturmel](https://forum.inductiveautomation.com/u/pturmel)\
**Post date:** [September 12, 2025, 11:20am UTC](https://forum.inductiveautomation.com/t/insert-query-show-error/110566/6 "2025-09-12T11:20:10Z")

</div>

> [@Transistor](#):
>
> What was the clue

You quoted it. Updates do not return result sets.