pdDate = {} SQLEXEC(nHandl, "Update Users set Changed = ?pdDate") && Error message: Incorrect date value: '' for column users.ChangeD.The same works in MySQL without problems. Also when I change the code it would work, but I don't feel comfortable with this solution:
pdDate = 0 SQLEXEC(nHandl, "Update Users set Changed = ?pdDate")Also the following works:
pdDate = DATE() SQLEXEC(nHandl, "Update Users set Changed = ?pdDate")Is this a problem with the ODBC driver or some setting I could look at?