Re: How to Raise Error ?
Hi Vishal
MySQL uses ANSI procedural language (SQL/PSM). ANSI offers a method to raise errors but at present this hasn't been implemented by MySQL.
There are a couple of solutions to the problem, neither of which are ideal but do offer some short term method to deal with the problem.
You can either do it via a procedure/table combination which is explained here.
http://mysql.gilfster.com/page.php?parent_id=2&page_id=2.0.7
Or you can use a view
http://www.livejournal.com/users/arjen_lentz/49881.html
The second method doesn't return a particualry helpfull message but it depends if thats a problem for your application or not
Regards
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
Edited 1 time(s). Last edit at 11/17/2005 06:59AM by Andrew Gilfrin.
Subject
Views
Written By
Posted
25004
November 17, 2005 04:00AM
Re: How to Raise Error ?
16707
November 17, 2005 06:58AM
23665
November 19, 2005 08:53AM
14485
February 23, 2006 02:28AM
10774
February 23, 2006 04:42AM
15434
February 24, 2006 08:28AM
8473
February 24, 2006 10:15AM
6250
February 24, 2006 12:42PM
7879
February 27, 2006 08:56AM
6678
February 27, 2006 11:27AM
18863
February 28, 2006 05:22AM
6525
December 20, 2006 03:34AM
4086
November 18, 2008 08:28AM
4733
November 18, 2008 12:45PM
6141
December 19, 2006 11:00AM
4945
December 19, 2006 02:35PM
6201
December 19, 2006 07:53PM
4392
December 20, 2006 03:37AM
4603
December 19, 2006 11:01AM
5479
November 24, 2006 05:32AM
4455
November 24, 2006 07:02AM
3600
December 23, 2008 06:08AM
11135
February 25, 2006 11:48PM
8265
April 06, 2007 02:42AM
5707
April 06, 2007 05:16AM
4935
December 19, 2007 04:24AM
3907
December 24, 2008 01:02PM
4752
December 19, 2007 03:59AM
4613
December 19, 2007 05:09AM
3510
November 18, 2008 08:25AM
3891
November 18, 2008 12:49PM
5991
December 19, 2007 04:46AM