Hello All. I am setting up a dynamic checklist and am running into some issues getting the MSSQL queries to pan out. The broad scope is to update initials from a text-box into a database that my checklist table reads its values from; then to store a snapshot of current data in an unseen logbook; the…

Anything that isn't a SELECT needs to use system.db.runPrepUpdate().

Thanks, I wasn't sure of the difference between the two commands and was using them more or less interchangeably. This resolved the error return.

"Statement does not return results" Error on INSERT INTO script

ignition81, vision, database, scripting

show post in topic

Powered by Discourse, best viewed with JavaScript enabled