Re: How to Raise Error ?

[Andrew Gilfrin]

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.