Results 1 to 1 of 1

Thread: Trigger help

  1. #1
    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 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.

    Any suggestions?
    Attached Files Attached Files

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts