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 |
|
ganeshkumar08
Posting Yak Master
187 Posts |
 Posted - 2010-06-10 : 05:59:24
|
| Hi All,I have a table called Frames with 6 columns, like ID,matchID,inningsID,Filepath,StartFrame,EndFrame.I have a data rows in that table.In that table i have a row whose matchID = 446.Only for this matchID i was not able to Update. If i update that row automatically it will have empty column. This is query.Update FRAMES set END_FRAME= 'Picture 12345' Where MATCH_ID= 446 And Innings=2this is not working, always it shows empty column after update.Can i know what will be the problem. I dont have any trigger on it or no relationship is available on it.thanksGaneshSolutions are easy. Understanding the problem, now, that's the hard part |
|
|
dinakar
Master Smack Fu Yak Hacker
2507 Posts |
Posted - 2010-06-10 : 17:17:49
|
| Is there any trigger on the table thats voiding your update?Dinakar Nethi************************Life is short. Enjoy it.************************http://weblogs.sqlteam.com/dinakar/ |
 |
|
|
|
|
|
Problem in updating a columnin a Table