![]() ![]() All my existing SQL statements should work with minor changes. So lets say I use Valentine SQLite Server. SQLPS.SQLExecute(em,System.EnvironmentVariable("COMPUTERNAME")) SQLPS = ("INSERT INTO ErrorLog(Value,User,Time) VALUES(?,?,DATETIME(CURRENT_TIMESTAMP,'LOCALTIME'))") Sub ErrCheck(Extends DB as SQLiteDatabase, msg as String = "", Log as Boolean = True)ĭim em As String = "Error: " + db.ErrorMessage + EndOfLine + msg I check for errors after every db read or write. ![]() Windows 7 if that makes a difference.ĭim rs as RecordSet = MainDb.SQLSelect("SELECT * FROM ProductionProgress WHERE ProductionID = '" + PID + "' ORDER BY Idx") Also the db is at a networked location on another computer. It is possible that another user is writing to the db at the time it is being read. I might also mention that this method is being called from a timer once a second max (when certain flags are true). Here is the (seemingly normal) statement where the problem occurs. I’ve noticed that half the time the error logging mechanism (see error logging details below), doesn’t write the error back to the db.Īnother thing that is unsettling is that it only happens on one computer, and at only one place in the code. Also everything continues to work properly. ![]() What makes my problem unique, is that an integrity check returns ok. I’ve googled this error and found useful information about how to restore corrupted databases. Hi I just installed a newer version of my program, and now one of my users is getting an occasional error. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |