Re: How to Raise Error ?
Hi Andrew,
yes, just as I was doing my groceries (after submitting the post, grrrr) I thought about that one too. I mean, I would rather like MySQL check my code for non-existing tables, columns, procs etc before accepting the code, and I would not be surprised if that feature would be implemented someday (have you put up a feature request?).
And of course, the proc should be flagged vaild or invalid just like in Oracle. To top it off, I would really like something like DBA_DEPENDENCIES view, or the equivalents defined in the standard.
I'm a bit confused as to what you mean by 'the table method'. I thought we established three flavours of work-arounds to fora an error:
1) violate unique constraint as documented at mysqldevelopment.com ('emulating check constraints')
2) reference non-existant procedure (Zigmunds suggestion)
3) UDF (as documented in my blog)
Subject
Views
Written By
Posted
25317
November 17, 2005 04:00AM
16836
November 17, 2005 06:58AM
23796
November 19, 2005 08:53AM
14610
February 23, 2006 02:28AM
10873
February 23, 2006 04:42AM
15606
February 24, 2006 08:28AM
8578
February 24, 2006 10:15AM
Re: How to Raise Error ?
6361
February 24, 2006 12:42PM
7980
February 27, 2006 08:56AM
6769
February 27, 2006 11:27AM
18977
February 28, 2006 05:22AM
6627
December 20, 2006 03:34AM
4178
November 18, 2008 08:28AM
4843
November 18, 2008 12:45PM
6271
December 19, 2006 11:00AM
5067
December 19, 2006 02:35PM
6309
December 19, 2006 07:53PM
4493
December 20, 2006 03:37AM
4710
December 19, 2006 11:01AM
5585
November 24, 2006 05:32AM
4551
November 24, 2006 07:02AM
3694
December 23, 2008 06:08AM
11358
February 25, 2006 11:48PM
8370
April 06, 2007 02:42AM
5795
April 06, 2007 05:16AM
5031
December 19, 2007 04:24AM
4012
December 24, 2008 01:02PM
4835
December 19, 2007 03:59AM
4716
December 19, 2007 05:09AM
3589
November 18, 2008 08:25AM
3973
November 18, 2008 12:49PM
6098
December 19, 2007 04:46AM