Re: How to Raise Error ?
Roland,
"I'm a bit confused as to what you mean by 'the table method'."
I was getting a bit confused with another post which was trying to use the non-existant procedure method but using a select on a non-existant table instead. That works OK in procedures but not in triggers.
Andy,
Thats very similar to the method shown here...
http://mysql.gilfster.com/page.php?parent_id=2&page_id=2.0.7
Your suggestion is a good one in that it requires nothing more than a procedure call, but as you and us mentioned it's all a bit artificial.
Andrew Gilfrin
------------------
http://gilfster.blogspot.com
My MySQL related Blog
http://www.mysqldevelopment.com
MySQL Stored Procedure,Trigger, View.... (Just about most things these days) Information
Subject
Views
Written By
Posted
25906
November 17, 2005 04:00AM
17037
November 17, 2005 06:58AM
24020
November 19, 2005 08:53AM
14860
February 23, 2006 02:28AM
11135
February 23, 2006 04:42AM
15847
February 24, 2006 08:28AM
8773
February 24, 2006 10:15AM
6551
February 24, 2006 12:42PM
Re: How to Raise Error ?
8201
February 27, 2006 08:56AM
6935
February 27, 2006 11:27AM
19170
February 28, 2006 05:22AM
6866
December 20, 2006 03:34AM
4344
November 18, 2008 08:28AM
5038
November 18, 2008 12:45PM
6551
December 19, 2006 11:00AM
5272
December 19, 2006 02:35PM
6521
December 19, 2006 07:53PM
4671
December 20, 2006 03:37AM
4900
December 19, 2006 11:01AM
5787
November 24, 2006 05:32AM
4748
November 24, 2006 07:02AM
3885
December 23, 2008 06:08AM
11715
February 25, 2006 11:48PM
8571
April 06, 2007 02:42AM
5972
April 06, 2007 05:16AM
5220
December 19, 2007 04:24AM
4244
December 24, 2008 01:02PM
5015
December 19, 2007 03:59AM
4926
December 19, 2007 05:09AM
3759
November 18, 2008 08:25AM
4178
November 18, 2008 12:49PM
6311
December 19, 2007 04:46AM