Re: BPCS 6.0.4 GUI - order entry locks on an order during maintenan ce

[brobins@xxxxxxxxxxxxx]

A more complete method would be to:

Select hord,count(*) from ech group by hord having count(*)>1

It might be advisable to substitute echl01 instead of ech, but either will work.

Bill

Boris Goldenberg wrote:

> Based on the SQL message, sounds like you might have duplicate records
> in your ECH file. To check whether that is the case:
>
> Type STRSQL and enter the following statement:
>
> select * from ech where hord = xxxxxx
>
> where xxxxxx is your order number.  There should only be one record in
> ECH.  If more than one, you should delete one of them.
>
> Regards,
>
> Boris Goldenberg
>

+---
| This is the BPCS Users Mailing List!
| To submit a new message, send your mail to BPCS-L@midrange.com.
| To subscribe to this list send email to BPCS-L-SUB@midrange.com.
| To unsubscribe from this list send email to BPCS-L-UNSUB@midrange.com.
| Questions should be directed to the list owner: dasmussen@aol.com
+---