MySQL Forums
Forum List  »  Triggers

Advanced Search
New Topic

Re: Can't update table 'tbl' in stored function/trigger because it is already used by statement which invoked this stored function/trigger
Posted by: Andrej Nagy
Date: January 05, 2009 02:55PM

As you said it is not possible to update a table for for which the trigger is created in the trigger. I ended up with removing the trigger and handling the action in the procedure (InsertRecord, DeleteRecord, UpdateRecord). All modifications than have to be done using this procedures.

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
Can't update table 'tbl' in stored function/trigger because it is already used by statement which invoked this stored function/trigger
71748
Georg
October 19, 2006 02:47PM
Re: Can't update table 'tbl' in stored function/trigger because it is already used by statement which invoked this stored function/trigger
38857
Christian Trummer
October 20, 2006 11:03AM
Re: Can't update table 'tbl' in stored function/trigger because it is already used by statement which invoked this stored function/trigger
24457
Georg Klaissner
October 20, 2006 03:06PM
Re: Can't update table 'tbl' in stored function/trigger because it is already used by statement which invoked this stored function/trigger
22684
mikeryksen
December 07, 2006 01:38PM
Re: Can't update table 'tbl' in stored function/trigger because it is already used by statement which invoked this stored function/trigger
25576
Jody Robbins
March 18, 2008 10:13AM
Re: Can't update table 'tbl' in stored function/trigger because it is already used by statement which invoked this stored function/trigger
18197
Peter Betzler
November 21, 2006 10:43PM
Re: Can't update table 'tbl' in stored function/trigger because it is already used by statement which invoked this stored function/trigger
19039
b G
December 24, 2006 01:06PM
Re: Can't update table 'tbl' in stored function/trigger because it is already used by statement which invoked this stored function/trigger
16962
Maarten Abbink
August 01, 2007 02:02PM
Re: Can't update table 'tbl' in stored function/trigger because it is already used by statement which invoked this stored function/trigger
13052
Roberto Fonseca
April 23, 2008 08:46PM
Re: Can't update table 'tbl' in stored function/trigger because it is already used by statement which invoked this stored function/trigger
13509
Matt Price-Hutchinson
May 15, 2008 04:50AM
Re: Can't update table 'tbl' in stored function/trigger because it is already used by statement which invoked this stored function/trigger
11323
Matt Price-Hutchinson
May 15, 2008 04:51AM
Re: Can't update table 'tbl' in stored function/trigger because it is already used by statement which invoked this stored function/trigger
12827
Saul Azcano
June 26, 2008 09:32AM
Re: Can't update table 'tbl' in stored function/trigger because it is already used by statement which invoked this stored function/trigger
12065
Enrique Delgado
August 06, 2008 04:27PM
Re: Can't update table 'tbl' in stored function/trigger because it is already used by statement which invoked this stored function/trigger
25360
Andrej Nagy
January 05, 2009 02:55PM
Re: Can't update table 'tbl' in stored function/trigger because it is already used by statement which invoked this stored function/trigger
13024
Brian Dieckman
February 25, 2009 10:58AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.