I have an issue where an entry is not updating a column in the DB if the value is set to 0. The row is being updated as I attached an object and changed the Name column as well as setting the count column to 0 (it's currently set to 10). The name updated but the count stayed at 10. If I set the count to anything other than 0 it also gets updated...
There is nothing is built into SQL Server that would cause a zero to be rejected and other values to be accepted, so it is something in your code.
It would be hard to offer any suggestions without seeing the code and the table structure. It may be that there is a code segment that checks for zero in the value passed in; or it could be a trigger on the table that reverts when a value of zero is inserted, or it could be anything in between.
Setting SQL int value to 0 is not updating in the
Posted - 04/29/2012 : 07:43:34
