| Before update trigger ?? [message #57818] |
Wed, 09 July 2003 00:10  |
Suresh
Messages: 189
Registered: December 1998
|
Senior Member |
|
|
I have a production database and every end user should have the update privilege on one main table according to requirement. Required scripts had been given to production staff to update. But unfortunately some of them are updated the data without using scripts. Sometimes without giving where condition they used to update the table. Actually they used to update maximum of 200 rows by giving 'where' condition.
Here I want to do write a trigger if an user tries to do update more than 200 rows on particular table. The trigger will not allow to do that. How can I do that ? Please anybody give me the code for the (before update )trigger to avoid the above situation.
Thanks&Regards,
Suresh.
|
|
|
|
| Re: Before update trigger ?? [message #57820 is a reply to message #57818] |
Wed, 09 July 2003 02:39  |
sujit
Messages: 94
Registered: April 2002
|
Member |
|
|
Hi,
You can use instead of trigger in which you can query the database using their update command. if the query brings more than 200 rows raise error. else update. Hope this will work
Sujit
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
