On Wednesday, 11. July 2001 17:28, you wrote:
> Mike Mascari writes:
> > MESSAGE ON INDEX i_employees IS
> > 'An employee with a matching Social Security number already exists';
> >
> > Then, when the UNIQUE constraint of the index is violated, instead of
> > the message:
> >
> > 'Cannot insert a duplicate key into a unique index i_test1'
> >
> > the client application would receive:
> >
> > 'An employee with a matching Social Security number already exists'
>
> I think what you're after is
>
> TRY
> BEGIN
> INSERT ...
> END
> CATCH SQLCODE 12345 -- made up
> BEGIN
> RAISE 'your message here'
> END
>
> I'm positive people would kill for that kind of feature.
Then we should use this syntax (like Oracle does):
BEGIN INSERT ....
EXCEPTION WHEN .... THEN RAISE 'your message here'
END
Regards,
Klaus
--
Visit WWWdb at
http://wwwdb.org