Update trigger [message #322625] |
Sun, 25 May 2008 06:10  |
hany_marawan
Messages: 198 Registered: April 2005 Location: Cairo - Egypt
|
Senior Member |
|
|
Hello,
I Want to build database trigger on table to make it not updated.
How can I do this.
Thanks
|
|
|
|
Re: Update trigger [message #322671 is a reply to message #322625] |
Sun, 25 May 2008 21:42   |
TheSingerman
Messages: 49 Registered: April 2008 Location: Brighton, Michigan
|
Member |
|
|
And to add to Littlefoot's advice (which is all very good) spend some time analyzing exactly what it is you are trying to do, and why a trigger is the best way to accomplish it. The standard way to "unupdate" a table is to issue a rollback. Works 100% of the time. You are saying that a rollback will not work in your situation. Which suggests strongly that you have a situation where, if you don't know exactly what you are doing, you will really corrupt your database.
|
|
|
|