| validate item [message #86908] |
Fri, 19 November 2004 04:15 |
Mara Duarte
Messages: 2
Registered: November 2004
|
Junior Member |
|
|
could any one please tell me, what is wrong with this code, or what should i add, or do?!?
declare v_qtd_disp exist_material.qtd_disp%type;
begin
select qtd_disp
into v_qtd_disp
from exist_material e, ord_tip_op oto
where oto.idmaterial=:ordem_e_operacao.idmaterial and oto.idmaterial=e.idmaterial;
if(v_qtd_disp < :ordem_e_operacao.QTD_MAT_PREV) then
message('the qtd you want doesn't exists!!!!');
end if;
end;
I put this code in when-validate-item trigger in the item QTD_MAT_PREV in the block ordem_e_operacao.
What i want, is too validate the item QTD_MAT_PREV in block ordem_e_operacao, according to the value in the item qtd_disp in the table exist_material.
Is it possible???
I would be very thunkfull if some one could help me.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
