Ignition 7.9.20 on Windows 12 Server
SQL Server 2019 on another computer.
For 7 years we have had the following working in a python script:
sql = \
"""
INSERT INTO table (col_1, col_2, col_3)
VALUES (?, ?, ?)
"""
system.db.runPrepUpdate(sql, [1, 2, 3])
Yesterday this started throwing errors "A result set was generated for an update...."
The script was changed to:
sql = \
"""
SET NOCOUNT OFF
INSERT INTO table (col_1, col_2, col_3)
VALUES (?, ?, ?)
"""
system.db.runPrepUpdate(sql, [1, 2, 3])
And it now works. Any idea why this failure could happen and why the fix fixes it?
TIA
Mack