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