Issuing this INSERT INTO statement returns a dbError = 0 even after a commit is issued. This statement is the 3rd of 3 separated by ;
INSERT INTO ledger(id, memberID, points, isPointBoost, note, created, createdBy) VALUES('dCF18FfC-1B7F-4a6C-B8Ad-ccceAfadeDBe', 'd860498d-4d1c-42df-8d0d-e62b190e8035', 5, 0, [SQL] 'Syntax Error', 1508073472, 'ABeDc18C-d5cf-4EcE-B9B5-dCaFfE826d8F')
If I try to execute this statement through the MySQL CLI (Ubuntu) I get
Thoughts?
MySQL: 5.6.33-0ubuntu0.14.04.1 (Ubuntu)
OS (Dev): Mac OS High Sierra
App: Web project
Xojo: 2016r11
Xojo MySQL plugin: 4/27/2016 1:12 PM (10.9MB)
[code]Function ConnectSQL(liveMode As Boolean) As Boolean
db = New MySQLCommunityServer
' Open connection to database
db.Host = App.dbHost
db.Port = App.dbPort
db.DatabaseName = App.dbName
db.UserName = App.dbUser
db.Password = App.dbPassword
if db.Connect then
db.SQLExecute(“SET NAMES ‘utf-8’”)
dbErrMsg = “”
dbErrNum = 0
Return True
else
dbErrNum = db.ErrorCode
dbErrMsg = db.ErrorMessage
Return False
end if
End Function
Function ExecuteSQL(SQL As String) As Boolean
if db.Connect then
db.SQLExecute(“START TRANSACTION;” + SQL + “;”)
end if
if db.Error then
dbErrNum = db.ErrorCode
dbErrMsg = db.ErrorMessage
db.Rollback
App.LogDebug(enumLogLevel.Error, enumLog.Database, CurrentMethodName, dbErrNum, dbErrMsg, SQL)
Return False
else
dbErrMsg = “”
dbErrNum = 0
db.Commit
App.LogDebug(enumLogLevel.Information, enumLog.Database, CurrentMethodName, dbErrNum, dbErrMsg, SQL)
Return True
end if
End Function
[/code]