It's not been a good day. First, I found out that Commits and Rollsbacks don't like to work in MS SQL Server because of a bug Feedback Case #32121.
So we switched to ODBC to the same MS SQL Server database and a simple Insert in a transaction doesn't like to insert. DB shows no errors either. Anybody seen this? This provides no error but no insert either:
db.SQLExecute("Begin transaction") if db.error then break end if db.SQLExecute("insert into addresses (Name, Active) values('GEOFFRY',0)") if db.Error then break end if db.Commit if db.error then break end if
All done with 2017 R3.