Re: How to Raise Error ?
To raise error in transaction or trigger the best way is to use not existable procedure. For example:
delimiter |
create trigger settings_before_insert before insert on _settings
for each row
begin
if (select ifnull(count(*),0) from _settings)=1 then
call ERROR_INSERT_NOT_ALLOWED();
end if;
end;
| delimiter;
And then in Delphi (of course) you simply can intercept this exception and show your message instead of this. Of course procedure ERROR_INSERT_NOT_ALLOWED must not exist.
I saw stupid decision of this problem with using a table with unique index on some field and insert then two same records - don't use this stupid method, my method is better.
Subject
Views
Written By
Posted
25018
November 17, 2005 04:00AM
16712
November 17, 2005 06:58AM
23668
November 19, 2005 08:53AM
Re: How to Raise Error ?
14491
February 23, 2006 02:28AM
10780
February 23, 2006 04:42AM
15438
February 24, 2006 08:28AM
8474
February 24, 2006 10:15AM
6251
February 24, 2006 12:42PM
7880
February 27, 2006 08:56AM
6679
February 27, 2006 11:27AM
18865
February 28, 2006 05:22AM
6528
December 20, 2006 03:34AM
4094
November 18, 2008 08:28AM
4737
November 18, 2008 12:45PM
6148
December 19, 2006 11:00AM
4951
December 19, 2006 02:35PM
6205
December 19, 2006 07:53PM
4397
December 20, 2006 03:37AM
4604
December 19, 2006 11:01AM
5484
November 24, 2006 05:32AM
4459
November 24, 2006 07:02AM
3604
December 23, 2008 06:08AM
11149
February 25, 2006 11:48PM
8269
April 06, 2007 02:42AM
5710
April 06, 2007 05:16AM
4937
December 19, 2007 04:24AM
3910
December 24, 2008 01:02PM
4754
December 19, 2007 03:59AM
4616
December 19, 2007 05:09AM
3512
November 18, 2008 08:25AM
3895
November 18, 2008 12:49PM
5994
December 19, 2007 04:46AM