Re: INTEGRITY CHECK CONSTRAINTS ORACLE 8i

From: Ganesh Raja <ganesh_at_gtfs-gulf.com>
Date: Wed, 6 Feb 2002 12:39:15 +0400
Message-ID: <a3qq5i$1j19@news-dxb.emirates.net.ae>

If you dont have the source to that application how will you achieve this....

Are you calling a stored procedure or a Function that willl return some value on insertion or Failure.

if so you can do it....

Pls get back with details to the group.

--
HTH

Additions and Corrections Welcome.

Regards,
Ganesh R


"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:39:15 CST