Oracle ODBC Error handling

From: Diederik Klaassen <dklaassen_at_lucent.com>
Date: 1997/09/01
Message-ID: <01bcb6a3$2721c3e0$44475587_at_nl00063608047>#1/1

[Quoted] Hello all,

I am creating an application in Access 7.0 which is using an Oracle 7.3 database.
The database model includes all kinds of referential integrity checking. For every screen I created on this database I have written all kinds of checking
functions like :

	Before an inasert new: does the primary key already exist ?
	Before a delete: Are there any related records ?

This all to prevent Oracle from showing a more or less cryptical error message
(and Access one generic ODBC error message of its own). However, if I could suppress the Oracle message and intercept the errorcode,
I would not have to do all these checking at first. I could just show a message
and roll back the action.

So, is there a way to suppress the Oracle and Access errors and to attach some
customized errorhandling ?

	Thanks for the help,
	Diederik Klaassen
	dklaassen_at_lucent.com

Received on Mon Sep 01 1997 - 00:00:00 CEST