1175 Script continues after BeginTransaction/Commit

[Bex]

Are you using Attach/Detach?
If you post your code, I'll have a look.

[mistresso]

Nah, this is simply songdata updates - I am running some performance tests and keep running into database lock issues. I will post in a separate thread when I have more information. I'm using a .Net "wrapper" around the SQLite implementation, so the issues could be coming from a conflict between how THAT code works its connections to the MM database and how the internal MM API does it. SQLite has some... weirdness... to it, particularly in how it handles transactions/locks and connections. And while it's pretty obvious that the MM API's BeginTransaction and the .Net SQLite provider's BeginTransaction are basically calling the same pieces of SQLite (same with Commit, pretty normal stuff for talking to databases), it seems odd to me that we have no rollback functionality... or any way to 'unlock' the database (or check for a lock).

[Teknojnky]

songdata object does not need or use explicit commit functions in script, they are only used for opensql queries.

however songdata object may use commits 'behind the scenes', but all the script need worry about is using the update functions.