Am using Powerbuilder, v6.5.1 and Oracle 8.1.6 on WINNT. Would like to
create a 'Before Insert' or 'Update' trigger on a particular table, and in
this trigger validate 7 fields from the database. My question: if a
validation fails(lets say, the first 3 are fine, but the 4th errors), then,
I would like to stop the further processing of the trigger, and if possible,
return an error message to the user, telling him where the failure was. Is
this possible? A colleague suggested that I couldn't code in the trigger a
Messagebox(from Powerbuilder) with an appropriate message, because at this
point(the middle of a trigger) I was in the Oracle environment. What do you
think?
Received on Thu Jun 21 2001 - 21:38:18 CDT
