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
25080
November 17, 2005 04:00AM
Re: How to Raise Error ?
16740
November 17, 2005 06:58AM
23700
November 19, 2005 08:53AM
14522
February 23, 2006 02:28AM
10803
February 23, 2006 04:42AM
15469
February 24, 2006 08:28AM
8499
February 24, 2006 10:15AM
6285
February 24, 2006 12:42PM
7903
February 27, 2006 08:56AM
6701
February 27, 2006 11:27AM
18892
February 28, 2006 05:22AM
6548
December 20, 2006 03:34AM
4115
November 18, 2008 08:28AM
4761
November 18, 2008 12:45PM
6175
December 19, 2006 11:00AM
4974
December 19, 2006 02:35PM
6230
December 19, 2006 07:53PM
4418
December 20, 2006 03:37AM
4626
December 19, 2006 11:01AM
5506
November 24, 2006 05:32AM
4483
November 24, 2006 07:02AM
3627
December 23, 2008 06:08AM
11210
February 25, 2006 11:48PM
8296
April 06, 2007 02:42AM
5732
April 06, 2007 05:16AM
4955
December 19, 2007 04:24AM
3931
December 24, 2008 01:02PM
4777
December 19, 2007 03:59AM
4637
December 19, 2007 05:09AM
3533
November 18, 2008 08:25AM
3915
November 18, 2008 12:49PM
6016
December 19, 2007 04:46AM