Can't Delete Row (Grid editing error) (0 rows deleted when that should have been 1.)
Can't seem to delete a record. I can do it from a Query with sql but not by right clicking on the record and choosing delete. What am I doing wrong?
I looked deeper into this and I saw this message at the bottom /* SQL Error (241): Conversion failed when converting date and/or time from character string. */. I noticed what the problem was. It was using a different date format when writing the delete script. It used '19/01/2015 13:21:00' and my date field was in this format '2015-01-19 13:21:00.0000000'. So now my question is, how do I make HeidiSQL use the correct date format when writing its own SQL Queries?
Please login to leave a reply, or register at first.