Can't Delete Row (Grid editing error) (0 rows deleted when that should have been 1.)

[expired user #8573]'s profile image [expired user #8573] posted 9 years ago in General Permalink
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?
BubikolRamios's profile image BubikolRamios posted 9 years ago Permalink
by right clicking on the record and choosing delete

Because it is probably not there any more. Refresh table data display before attempting to delete.
[expired user #8573]'s profile image [expired user #8573] posted 9 years ago Permalink
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?
ansgar's profile image ansgar posted 9 years ago Permalink
Some other user here in the forum and the Microsoft documentation said that '19/01/2015 13:21:00' is a universal date/time format which should always work. It's a mess on MSSQL. Please find me a date/time format which works on all servers.

Please login to leave a reply, or register at first.