Re: Trigger Error

[Omar Jonguitud]

Hi Roland, definitely i dont want to raise error because i like. This is my problem:

DECLARE _i_ea_numero int;

SELECT _i_ea_numero = i_ea_numero
FROM
tblEea enc
WHERE
enc.str_suc_clave = new.str_suc_clave and
enc.i_nc_numero = new.i_nc_numero;

/** aqui va otro update ***/


UPDATE tblDea
SET
flo_dea_devueltos = flo_dea_devueltos + new.flo_dnc_cantidad_articulos
WHERE
dea.str_suc_clave = new.str_suc_clave and
dea.i_ea_numero = _i_ea_numero and
dea.ti_ea_num_partida = new.ti_dnc_numpartida;


In the first select, i need the value of a master catalog so i write a select to get the value in a variable that i use later in that update below. If I cant get that value i cant update data in the catalog. So what should i do? Thanks in advance