Hello,
So I have an app that connects to a MySQL server , and I have the following code :
[code]rs = App.sqlBase.SQLQuery(sql)
System.DebugLog("App.EnableInt -> sql : " + sql)
If rs <> Nil Then
System.DebugLog("App.EnableInt -> rs recordCount : " + rs.RecordCount.ToText)
If rs.RecordCount = 1 Then
rs.Edit
System.DebugLog("App.EnableInt -> rs.Field('state') = : " + rs.Field("state").StringValue)
If rs.Field("state").IntegerValue = 0 Then
rs.Field("integrator").StringValue = Integrator
rs.Field("status").StringValue = SetStatus(State)
rs.Field("state").IntegerValue = State
'Check integrations status
rs.Field("isEnabled").StringValue = State.ToText
rs.Update
If App.sqlBase.Error Then
System.DebugLog("App.EnableInt -> App.sqlBase.Error : " + App.sqlBase.ErrorMessage)
End If
End If
End If
rs.Close
End If[/code]
So if I run same code with breakpoint on the code it updates the database, but if I turn the breakpoints off and run the code it does not update the table. Same code, that is super weird, the DB does not throw any error but in the same time it does not update the record as well.
Any ideas ?
OSX 10.14.4 and 10.13.6
Compiled and tested on XOJO 2019R1