By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
437,542 Members | 1,434 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 437,542 IT Pros & Developers. It's quick & easy.

I dont know the error with updtae

P: n/a
Hi!
I have a trigger using a update but this doestn work into trigger but if I
execute the update from pgadmin this works perfectely.

This is the code
select into registro * from t_pagos_comisiones where f_wholetipoagnivel =
who and f_fecha = $4 for update;
IF FOUND THEN
IF ($5 >0) THEN
t1:= registro.f_montopagado+$7;
t2:= registro.f_montocomision+$5;
raise notice '' hacer el update t1 y t2 %, %'',t1,t2;
--f_montocomision=t2
UPDATE t_pagos_comisiones SET
f_montopagado=t1,f_montocomision=t2,f_nivel=90 where f_wholetipoagnivel
= who and f_fecha = vfecha;
end if;
end if;

*-------------------------------------------------------*
*-Edwin Quijada
*-Developer DataBase
*-JQ Microsistemas
*-809-747-2787
* " Si deseas lograr cosas excepcionales debes de hacer cosas fuera de lo
comun"
*-------------------------------------------------------*

__________________________________________________ _______________
¿Estás buscando un auto nuevo? http://www.yupimsn.com/autos/
---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

Nov 11 '05 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.