<https://xojo.com/issue/58073>
OS: Windows 10
Xojo: Xojo 2019r2
Steps: Do a SQL Insert using Prepared mySQL Statemtents and the new DateTime Object.
[code]Dim d As DateTime = DateTime.Now
ps = db.Prepare(“INSERT INTO wag_main_db.wag_main_log (short_description,log_message,created,created_by) VALUES (?,?,?,?)”)
ps.Bind(0, LogEntrySubject.ConvertEncoding(Encodings.WindowsANSI), MySQLPreparedStatement.MYSQL_TYPE_STRING)
ps.Bind(1, LogEntryBody.ConvertEncoding(Encodings.WindowsANSI), MySQLPreparedStatement.MYSQL_TYPE_STRING)
ps.Bind(2, d, MySQLPreparedStatement.MYSQL_TYPE_DATETIME)
// alt: ps.Bind(2, DateTime.Now, MySQLPreparedStatement.MYSQL_TYPE_DATETIME)
ps.Bind(3, App.Benutzer.WAG4UserID, MySQLPreparedStatement.MYSQL_TYPE_LONG)
db.ExecuteIt(ps)[/code]
The Column created is of mySQL Type DateTime.
In some cases this leads to a crash on Windows 10 64bit.
I would like to add, that the mySQL Server i use is access via SSL using Certifikates.
Did anybody else saw those?