|
Hi
I am getting a strange result when using the
following -
Select fluid_id into fluidid from p_id.processes where new.pump1 = 'True' and old.pump1 = 'False' or old.pump1 is null; The fluid_id return is fine when there is a single row. However with two
rows, and updating only one of the rows, I quite often get the fluid_id for the
other row.
I am using an After Update trigger.
Bob
|
