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 |
|
oguzkaygun
Yak Posting Veteran
53 Posts |
 Posted - 2012-03-10 : 13:10:48
|
| Hi.I have below code.I got error at SQL. What can be problem ?Thanks.const string sorguchupdate = @"UPDATE x_carihareketSET x_borcalacak = CASE WHEN x_borcalacak = @B THEN x_bakiye = x_bakiye + @x_borcWHEN x_borcalacak = @A THEN x_bakiye = x_bakiye - @x_borc WHEN x_borcalacak = @A THEN x_bakiye = x_bakiye + @x_alacakWHEN x_borcalacak = @B THEN x_bakiye = x_bakiye - @x_alacak WHERE x_harekettarihi > @x_harekettarihi"; Dictionary<string, object> dicchupdate = new Dictionary<string, object>(); dicchupdate.Add("x_harekettarihi", DateTime.Parse(x_harekettarihi.DateTime.Date.ToString()));//.EditValue.ToString())); dicchupdate.Add("A", "A"); dicchupdate.Add("B", "B"); dicchupdate.Add("x_borc", decimal.Parse(x_borc.Text)); dicchupdate.Add("x_alacak", decimal.Parse(x_alacak.Text)); |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-03-10 : 13:37:37
|
| your case statement doesnt make any sense. which column you want to update? x_borcalacak or x_bakiye ?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
oguzkaygun
Yak Posting Veteran
53 Posts |
Posted - 2012-03-10 : 13:48:06
|
| Thank you. I have solved this problem.i updated borcalacak column. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-03-10 : 13:53:31
|
| ok...can you post last solution for others to see?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
oguzkaygun
Yak Posting Veteran
53 Posts |
Posted - 2012-03-10 : 14:59:10
|
| UPDATE x_carihareketSET x_bakiye = CASE WHEN x_borcalacak = @B THEN x_bakiye + @x_borcWHEN x_borcalacak = @A THEN x_bakiye - @x_borc WHEN x_borcalacak = @A THEN x_bakiye + @x_alacakWHEN x_borcalacak = @B THEN x_bakiye - @x_alacak END WHERE x_harekettarihi > @x_harekettarihi |
|
|
|
|
|
|
Update Case When