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 |
|
christoff
Starting Member
7 Posts |
 Posted - 2009-10-16 : 08:33:14
|
| Greetings All-I have a dilemma with an update statement that is run on sql server 2000 by a third party c# program. This program runs an update statement on a record whenever the record is modified in the program(i.e by changing a value on a windows form and committing that change). The program updates a 'flag' field that another program monitors and performs some action based on that flag value.What I need to be able to do is prevent the application from updating that 'flag' field on certain actions in the c# program but allow it in another action. To this point I have been using triggers/stored procedures to try and do this without success.Any feedback on this will be greatly appreciated and let me know if I can provide more details.Thanks in advance,christoff |
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2009-10-16 : 08:39:06
|
The best way is to change that in the c# program but I think you know that...and it is not an option.The solution by trigger needs information about about that what you've called "certain action".Without "action"-information - how should the trigger work in right conditions?
No, you're never too old to Yak'n'Roll if you're too young to die. |
 |
|
|
christoff
Starting Member
7 Posts |
Posted - 2009-10-16 : 10:14:11
|
| Thanks for your quick response!Do you have any suggestions on how I might get the action info without changing the program?Is there a way to capture what outside 'force' is running the update and ignore that update?Thanks again.christoff |
|
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2009-10-16 : 10:23:12
|
Nope.I hoped that you can tell us how to know the condition / action.
No, you're never too old to Yak'n'Roll if you're too young to die. |
|
|
|
|
|
|
update quandry