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: 0     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: Gold      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: 0     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: 0     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: 0     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.





  • Return to Discussion Forum
  • Start new thread


  • Subscribe to Subscribers
    Active Members
    Today
      Last 7 Daysmore...

      Awards & Gifts
      Talk to Webmaster Tony John

      Online Members

      Raghav
      More...
       
      Copyright © SpiderWorks Technologies Pvt Ltd., Kochi, India

      
      
      
      

      Click the "Follow" button above to follow Tony John