Re: Order in Use

  Dan,

  You could use the following SQL statement to remove the in use flag from
  the order;

  Update "BPCSlibrary"/ECH set HINUSE=' ' where HORD= "your order number"
  and HINUSE='Y'

  Bob

    ----------------------------------------------------------------------

    From:  washburnccinc@xxxxxxx
    Reply-To:  "SSA's BPCS ERP System" <bpcs-l@xxxxxxxxxxxx>
    To:  bpcs-l@xxxxxxxxxxxx
    Subject:  Re: [BPCS-L] Order in Use
    Date:  Tue, 20 Sep 2005 10:19:37 -0400
    It is the HINUSE field in the ECH file.  It should be blanks.     Kevin
    W.

    -----Original Message-----
    From: Daniel Wilkins <dwilkins@xxxxxxx>
    To: bpcs-l@xxxxxxxxxxxx
    Sent: Tue, 20 Sep 2005 07:12:00 -0700
    Subject: [BPCS-L] Order in Use

    A user is getting the message "Order is in use at another workstation"
    and it's the same user that was updating and the session ended.

    Where can I find this parameter or what should I do. The user was
    updating an order through the order entry program.

    BPCS Version   6.1     Release   01

    Thanks,

    Daniel

    --
    This is the SSA's BPCS ERP System (BPCS-L) mailing list
    To post a message email: BPCS-L@xxxxxxxxxxxx
    To subscribe, unsubscribe, or change list options,
    visit: http://lists.midrange.com/mailman/listinfo/bpcs-l
    or email: BPCS-L-request@xxxxxxxxxxxx
    Before posting, please take a moment to review the archives
    at http://archive.midrange.com/bpcs-l.

    Delivered-To: WASHBURNCCINC@xxxxxxx
    --
    This is the SSA's BPCS ERP System (BPCS-L) mailing list
    To post a message email: BPCS-L@xxxxxxxxxxxx
    To subscribe, unsubscribe, or change list options,
    visit: http://lists.midrange.com/mailman/listinfo/bpcs-l
    or email: BPCS-L-request@xxxxxxxxxxxx
    Before posting, please take a moment to review the archives
    at http://archive.midrange.com/bpcs-l.

    Delivered-To: barohar@xxxxxxxxxxx