Forums » .NET » SQL Server »

Can't update table 'tbl' in stored function/trigger because it is already used by statemen


Posted Date: 25 May 2010      Posted By:: lulzim     Member Level: Bronze    Member Rank: 8092     Points: 1   Responses: 5



Can't update table 'tbl' in stored function/trigger because it is already used by statement which invoked this stored function/trigger.

In every insert statement i use will show this error.
Do u have any idea what kind of error is this.
Im using triggers in mysql.




Responses

#509673    Author: Asheej T K        Member Level: Diamond      Member Rank: 2     Date: 25/May/2010   Rating: 2 out of 52 out of 5     Points: 2

Same issue has been addressed in below links,

http://forums.mysql.com/read.php?99,122354,240978#msg-240978

http://forums.mysql.com/read.php?99,122354,122505#msg-122505


Regards,
Asheej T K
Microsoft MVP[ASP.NET/IIS]
DotNetSpider MVM


 
#509711    Author: Anil Kumar Pandey      Member Level: Diamond      Member Rank: 1     Date: 26/May/2010   Rating: 2 out of 52 out of 5     Points: 2

may be the table is already in used.. better to use transaction to avoid such things.

Thanks & Regards
Anil Kumar Pandey
Microsoft MVP, DNS MVM


 
#513450    Author: Mushtaque      Member Level: Silver      Member Rank: 610     Date: 05/Jun/2010   Rating: 2 out of 52 out of 5     Points: 2

check may be table is lock




 
#529506    Author: Jai Singh      Member Level: Bronze      Member Rank: 3748     Date: 20/Jul/2010   Rating: 2 out of 52 out of 5     Points: 2

In MySql there is no provision to write trigger to update
multiple row. if u want to update multiple row at a time through
trigger then write sp and call it from trigger;
jai singh


 
#529517    Author: Jai Singh      Member Level: Bronze      Member Rank: 3748     Date: 20/Jul/2010   Rating: 2 out of 52 out of 5     Points: 2

In MySql there is no provision to write trigger to update
multiple row. if u want to update multiple row at a time through
trigger then write sp and call it from trigger;if ur SP will not
work for this then call ur stored procedure at specific time interval.
jai singh


 
Post Reply

 This thread is locked for new responses. Please post your comments and questions as a separate thread.
If required, refer to the URL of this page in your new post.



Next : Multi Branch Data Replication in One Table (Argent)
Previous : Help me
Return to Discussion Forum
Post New Message
Category: SQL Server

Related Messages

Subscribe to Subscribers
Awards & Gifts
Talk to Webmaster Tony John

Online Members

Ayush Dhar
More...
Copyright © SpiderWorks Technologies Pvt Ltd., Kochi, India