Greetings!
The people who originally wrote the system I'm
trying to work with did not know as much as they should have about working with
databases, so I'm stuck with the following situation:
The applicaton is written in C++ (MS Visual C++ 6,
Windows XP, in case it matters). At one point, a required check was not
performed before data was saved. I cannot change this part of the C++
code, so I have to perform the check in the database, and the insert query has
to fail so that the application will see that something bad happened.
However, there's another query that gets performed before the one I have to
check. If the check fails, the earlier query has to be undone. The
only way I know to intentionally fail a query is to raise an exception.
However, raising an exception causes all earlier database changes to be
undone. How can I avoid that?
Here's what I need to do:
IF query_check_fails THEN
UPDATE some_table SET
some_value = 0 WHERE some_condition_is_true;
RAISE EXCEPTION 'Look, you
idiot, do it right next time!';
END;
I need the update to work, but I need to raise the
exception so the C++ code recognizes the error. How can I do
both?
Thanks very much!
RobR
