I am new to the forums and was hoping someone could clear up an issue for me.
I am building a form in a window and want to write a new record to a database when they click a button.
Attached is the code I’m using.
It writes to the SQL just fine, but doesn’t show up on my form.
I suspect I am handling the system.db.startTransaction, system.db.commitTransaction, and system.db.closeTransaction wrong, as I have open process locks in my SQL, data in the tables, and nothing showing in my form.
Any help would be great.