You must Sign In to post a response.
  • Category: SQL Server

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

    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.
  • #509673
    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
    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
    check may be table is lock

  • #529506
    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
    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


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.