[First EE question here - so hoping the below is clear enough]
Wondered why no update was happening from a rather simple update statement in my variable: vMySQL.
Printed out the contents of vMySQL and applied the same update statement directly to the database - and it worked perfectly, so there is nothing wrong with the statement
Found the error using the below.
db.Execute vMySQL, dbSeeChanges + dbFailOnError
Have tried repair database, turning pc off and on, various lock settings in "Tools>>Options>>Advanced Tab", putting DBEngine.Idle dbFreeLocks just before the execute statement but nothing changes. Always get this error.
Any ideas from anyone? Any help would be much appreciated
Wondering if there is no "true" lock as I was able to stop the processing during debug mode, at the point where the execute statement, is and manually run the update statement successfully. I thought that since I could do that there that this would mean that there was no true lock?
Hoping you have some more ideas?