Named Query with Transaction

[dkhayes117]

He could check the number of expected rows affected with what were actually affected by the prepUpdate, then rollback if they don't match.

Here is a good post to look at
Script Benchmarking with Decorators Example - Ignition - Inductive Automation Forum

@HelloWorld

Would this not rollback all the ones that raise an exception and commit the ones that do not ?

It's all or nothing with the transaction, it's not individual transactions, it's individual queries inside one transaction, if anything fails everything inside the transaction will rollback unless you break them up into multiple transactions.