Peranandham
New Member
hi i'm new for progress.. started learning..
i have doubt in database trigger, that's i put my question here,
assume i write trigger like this
on delete of xxitm_mstr:
for each xxpod_det where xxpod_nbr = xxitm_nbr:
delete xxpod_det.
end.
on leave anywhere do:
.....
...
{run xxpo_mstr}
if i delete po_mstr it fires session trigger only not database trigger.
need solution for how to delete that.. whenever i delete po_mstr it deletes given item nbr which is which in that table only not in pod_detail table how can i do it?
i have doubt in database trigger, that's i put my question here,
assume i write trigger like this
on delete of xxitm_mstr:
for each xxpod_det where xxpod_nbr = xxitm_nbr:
delete xxpod_det.
end.
on leave anywhere do:
.....
...
{run xxpo_mstr}
if i delete po_mstr it fires session trigger only not database trigger.
need solution for how to delete that.. whenever i delete po_mstr it deletes given item nbr which is which in that table only not in pod_detail table how can i do it?
