Hello all I'm here to get help eliminating possible issues on my end before claiming there's a bug with Ignition. I'm writing some library functions that generically handle reporting requests. While doing so I'm breaking things apart as much as possible so that someone wanting to inspect the pipel…

Doing something like: query = """ UPDATE READS_ReportRequests SET [Status] = 'Processing'; SELECT @@ROWCOUNT AS RC; """ rc = system.db.runScalarPrepQuery(query, []) print rc Prints 1 and updates the row in the table. Seeing as it just "Returns the number of rows affected by the last statem…

IIRC, there's a bug in the v8.3 runPrepUpdate if there are no parameters to substitute.

query = """ UPDATE READS_ReportRequests SET [Status] = 'Processing' WHERE 1 = ? """ rc = system.db.runPrepUpdate(query, [1]) print rc Indeed affects a change in the database. I ended up using this pattern instead: query = """ DECLARE @claimed TABLE (ID INT); UPDATE READS_…

I believe this was fixed in 8.3.7. <a href="https://inductiveautomation.com/downloads/releasenotes/8.3.7#:%5C~:text=Fixed%20an%20issue%20where%20prepared%20statement%20calls%20passed%20empty%20parameter%20arrays%20would%20fail%20to%20execute%2C%20affecting%20system.db%20functions%20runPrepUpdate%2C%20runPrepQuery%2C%20runScalarPrepQuery%2C%20as%20well%20as%20Vision%20query%20bindings" class="inline-onebox" rel="noopener nofollow ugc">Ignition Release Notes for Version 8.3.7 | Inductive Automation .

Correct: [image] [IGN-15326]8.3 system.db.runPrepUpdate not throwing Ignition This issue will be fixed in tomorrow's nightly/the full release of 8.3.7.

SQL UPDATE statements silently fail in script console

Ignition

paul-griffith July 20, 2026, 4:34pm 6

Correct: