# A result set was generated for update

**URL:** <https://forum.inductiveautomation.com/t/a-result-set-was-generated-for-update/93626>\
**Category:** Ignition\
**Created:** [July 23, 2024, 7:29pm UTC](https://forum.inductiveautomation.com/t/a-result-set-was-generated-for-update/93626 "2024-07-23T19:29:10Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Patricio\_Guereque](https://avatars.discourse-cdn.com/v4/letter/p/50afbb/32.png) [@Patricio\_Guereque](https://forum.inductiveautomation.com/u/Patricio_Guereque)\
**Post date:** [July 23, 2024, 7:29pm UTC](https://forum.inductiveautomation.com/t/a-result-set-was-generated-for-update/93626/1 "2024-07-23T19:29:10Z")

</div>

I have a problem running this query on a query tag it returns "A result set was generated for update", but when I run it as a named query (substituting the parameters for test) it works, the problem isn't the parameters since the test query also shows this error in the query tag. The thing is I need this query in the query tag since it has parameters referencing other tags.

```python

SELECT COUNT(DISTINCT CAST(Fecha AS VARCHAR) + '_' + CAST(Hora AS VARCHAR)) AS TotalHorasMalas
FROM (
    -- Horas malas de Orujos
    SELECT CONVERT(DATE, FechaHora) AS Fecha, DATEPART(hour, FechaHora) AS Hora
    FROM Laboratorio_NIR
    WHERE Orujo_{[.]../Parameters.Line} > 2.8  
    AND FechaHora <= CAST('{[~]FinTurnoActual}' AS DATETIME)
    AND FechaHora > CAST('{[~]InicioTurnoActual}' AS DATETIME)
    
    UNION ALL
    
    -- Horas malas de Sólidos
    SELECT CONVERT(DATE, FechaHora) AS Fecha, DATEPART(hour, FechaHora) AS Hora
    FROM Laboratorio_Solidos
    WHERE (Porcentaje_C1 > 0.2  
        OR Porcentaje_C2 > 0.2
        OR Porcentaje_C3 > 0.2
        OR Porcentaje_C4 > 0.2
        OR Porcentaje_C5 > 0.2
        OR Porcentaje_C6 > 0.2
        OR Porcentaje_C7 > 0.2
        OR Porcentaje_C8 > 0.2)
    AND FechaHora <= CAST('{[~]FinTurnoActual}' AS DATETIME)
    AND FechaHora > CAST('{[~]InicioTurnoActual}' AS DATETIME)
    
    UNION ALL
    
    -- Horas malas de Acidez
    SELECT CONVERT(DATE, FechaHora) AS Fecha, DATEPART(hour, FechaHora) AS Hora
    FROM Laboratorio_FFA
    WHERE (FFA_C1 > 5 
        OR FFA_C2 > 5
        OR FFA_C3 > 5
        OR FFA_C4 > 5
        OR FFA_C5 > 5
        OR FFA_C6 > 5
        OR FFA_C7 > 5
        OR FFA_C8 > 5)
    AND FechaHora <= CAST('{[~]FinTurnoActual}' AS DATETIME)
    AND FechaHora > CAST('{[~]InicioTurnoActual}' AS DATETIME)
    
    UNION ALL
    
    -- Horas malas de Humedad
    SELECT CONVERT(DATE, FechaHora) AS Fecha, DATEPART(hour, FechaHora) AS Hora
    FROM Laboratorio_Humedad
    WHERE (Porcentaje_C1 > 0.3  
        OR Porcentaje_C2 > 0.3
        OR Porcentaje_C3 > 0.3
        OR Porcentaje_C4 > 0.3
        OR Porcentaje_C5 > 0.3
        OR Porcentaje_C6 > 0.3
        OR Porcentaje_C7 > 0.3
        OR Porcentaje_C8 > 0.3)
    AND FechaHora <= CAST('{[~]FinTurnoActual}' AS DATETIME)
    AND FechaHora > CAST('{[~]InicioTurnoActual}' AS DATETIME)
) AS HorasMalas;

```

---

<div class="post-metadata">

**Author:** ![zacht](https://avatars.discourse-cdn.com/v4/letter/z/ea5d25/32.png) [@zacht](https://forum.inductiveautomation.com/u/zacht)\
**Post date:** [July 23, 2024, 10:27pm UTC](https://forum.inductiveautomation.com/t/a-result-set-was-generated-for-update/93626/2 "2024-07-23T22:27:15Z")

</div>

What is the "query type" in the query tag? Based on your error, I would suggest you try 'Select' if it isn't set to that already.

 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/8/c/8cd746ecc6793a667f90a3f82a8627b643cf241e.png)

---

<div class="post-metadata">

**Author:** ![Patricio\_Guereque](https://avatars.discourse-cdn.com/v4/letter/p/50afbb/32.png) [@Patricio\_Guereque](https://forum.inductiveautomation.com/u/Patricio_Guereque)\
**Post date:** [July 24, 2024, 3:18pm UTC](https://forum.inductiveautomation.com/t/a-result-set-was-generated-for-update/93626/3 "2024-07-24T15:18:46Z")

</div>

Thanks! That actually worked! changed to Select 🙂