Re: Old/New

On Friday 22 January 2010 3:05:54 pm Bob Pawley wrote:
> This is the whole trigger
>
>
>
> Begin
>
> If new.pump1 = 'True'
>
> then
>
> Insert into p_id.devices (p_id_id, process_id, fluid_id, status,
> process_graphics_id, device_description)
> values (new.p_id_id, new.process_id, new.fluid_id, 'Pump #1', '11',
> 'Pump');
>
> End if;
>
> If new.pump2 = 'True'
>
> then
>
> Insert into p_id.devices (p_id_id, process_id, fluid_id, status,
> process_graphics_id, device_description)
> values (new.p_id_id, new.process_id, new.fluid_id, 'Pump #2', '11',
> 'Pump');
>
> End if ;
>
> RETURN NULL;
>
> END;
>
> Bob

The update statement -
update p_id.processes
   set pump1 = 'True'
   where p_id.processes.fluid_id = '3501' ;
updates the field pump1 to 'True'.

Is there more than one row in p_id.processes with p_id.processes.fluid_id
= '3501' ?

--
Adrian Klaver
adrian(dot)klaver(at)gmail(dot)com