Now there is no time for experiments.
When I update record, in all projects, I use template with a restore point. SQLite is quite paranoid about data integrity.
But I am using old version of pushit SQLite Library v1.10.0.85
Although I think on new versions, this template will work.
Here's the starting point: Wait (ms) with error pass-through
From what I remember at CLA Summits, this was unofficial up to 2016 (called a "macro" at this point in time). But the cat was waaaaaaaaaaay out of the bag, so NI spent time to make it a proper feature and malleable VIs started in 2017. The Type Specialization Structure was not quite ready for prime time for another year (2018).
There is this interesting blog on Linkedin :
https://in.linkedin.com/posts/jimkring_upgrading-to-new-labview-versions-is-for-activity-6972085040700686336-5gGw?trk=public_profile_like_view
Lapsus : the person in question is CTO not CEO.
Regards