Re: INTEGRITY CHECK CONSTRAINTS ORACLE 8i

From: Keith Boulton <kboulton_at_ntlworld.com>
Date: Wed, 6 Feb 2002 08:56:38 -0000
Message-ID: <q8688.132$gz6.97175@news11-gui.server.ntli.net>

The short answer is "you can't". In the trigger, you can either raise an error or not. The VB doesn't have adequate error handling, so crashes.

You could do something awful in the trigger like restore the original values after the update, delete any newly inserted record.

This could also then use a database alert to notify a second application running on the client pc to say that the record was invalid and has not been changed.

The whole thing is just too tacky to contemplate.

Jeanette Weldon <jeanette.weldon3_at_virgin.net> wrote in message news:o2X78.11605$jV2.790035_at_news2-win.server.ntlworld.com...
> I have created an integrity check constraint using the ALTER TABLE command
> which makes a column on a table mandatory under certain conditions.
However
> when the constraint is violated in the Visual basic form, a run-time error
> occurs and the application terminates . How can I intercept the runtime
> error , stop the application terminating and produce a message to say that
> the user must enter data in the field.
>
> N.B. I do not have access to the source code of the VB app so I am working
> at the table level.
>
> Jeanette
>
>
>
>
Received on Wed Feb 06 2002 - 02:56:38 CST