I have a few tables in my MS SQL db that I receive '0 rows deleted when that should have been x.'. One of the tables has a VARBINARY field that holds a file, so when the delete command passes through every column value instead of just the primary key. I reached out to you recently and you stated that my table didn't have a primary key and it is programmed to pass each variable if one does not exist.
I looked into this further and the primary key shows up in both Toad and Microsoft SQL DB Editor, but not in HeidiSQL. I have the primary key on my id (integer) field. I tried removing the primary key via Toad and then adding it via HeidiSQL. It saved successfully, but when I reload the DB it is still not showing up with a primary key and I can still not delete any records.
Please let me know if you need additional information to help troubleshoot what I am seeing.I am currently on v7.0.0.4217.
Sincerely,
~Joe
Primary Key Not Working
Yes, seems I just forgot to implement the detection of primary keys on MSSQL, so every UPDATE and DELETE comes with a WHERE clause on all table columns. See issue #2946.
Please login to leave a reply, or register at first.