Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
ianc22
Starting Member
2 Posts |
 Posted - 2012-04-29 : 07:43:34
|
| Hi,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...Any ideas?! |
|
|
sunitabeck
Master Smack Fu Yak Hacker
5155 Posts |
Posted - 2012-04-29 : 08:26:39
|
| 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. Post the code and table DDLs and I am sure people on the forum would be able to offer suggestions. If you need some guidance in posting, Brett's blog would help: http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx |
 |
|
|
SQL Basic
Starting Member
8 Posts |
Posted - 2012-05-25 : 05:47:29
|
| Do you have set and change "0" value with "10" ? |
|
|
|
|
|
|
Setting SQL int value to 0 is not updating in the