On 07/18/2012 03:20 PM, Bob Pawley wrote:
> When I substitute new.fluid_id for the actual fluid)id the expression
> returns the right value.
Huh? I thought that was what was causing the problem. From your original
post:
"
where p_id.fluids.fluid_id = NEW.fluid_id;
I receive an error ”record “new” has no field “fluid_id” “.
"
Per previous suggestion can we see?:
1)The trigger definition
2) The function.
--
Adrian Klaver
adrian(dot)klaver(at)gmail(dot)com