Thread: Trigger help
05-19-14, 13:39 #1Registered User
- Join Date
- Sep 2013
Unanswered: Trigger help
Attached is a trigger file.
The the following line does not appear to work and I don't know why.
UPDATE sched_mast SET qty_pack_slip = new_qty WHERE order_no = tmp_order;
The data is being set via a vb.net program.
The prior update
PDATE co_po_line SET qty_pack_slip = new_qty WHERE co_po_num = NEW.co_po_num AND co_po_line = NEW.co_po_line;Has the correct value.
I cannot see the RAISE NOTICE from the vb program.
I don't know how to fix or debug this.