RE: Always index if Event Approve

I'm going to speculate about why this is a problem to you...

I remember on that version that if we ever ended up with a large number of
records in Approve Events and wanted to post a series of them, we would
double click the first one then click 'POST'. The window would vanish, the
GHH record status was updated in the GHH table from '2' (Unposted) to '3'
(Posted), then the list of events to be approved would be refreshed before
allowing the user to move on to posting the next record. The longer the list
of records to be approved, the longer it took to refresh the list, and the
list was refreshed each time we hit post. The status flag is not indexed in
the GHH (GHH.HHSTAT) or the GLH (GLH.LHSTS), so I suppose it takes longer to
filter the list than it would if indexed. Have you identified that it is the
updating of indexes that takes so long? Is it possibly the re-reading that
takes so long?

Our workaround was to go into the [Options], [Filters] pull-down menu and
set the List Capacity to 1. The list refreshed much quicker allowing us to
post multiple records much faster.

The general problem of posting a series of events is solved in 6.04 by the
Multi-Post feature that allows you to select a range of events to approve in
batch.

George Sagen
BPCS Application Consultant
gsagen@primesourcetech.com <mailto:gsagen@primesourcetech.com>
http://www.primesourcetech.com 

PrimeSource Technologies, L.L.C.
7373 East Doubletree Ranch Road
Suite 150
Scottsdale, AZ 85258
(801)360-6360 Direct & VM 


.  -----Original Message-----
.  From: uucp@Uucp1.mcs.net [mailto:uucp@Uucp1.mcs.net]On Behalf Of Kusman
.  Lim
.  Sent: Thursday, October 07, 1999 3:32 AM
.  To: 'BPCS-L@midrange.com'
.  Subject: Always index if Event Approve
.
.
.
.  Dear Guys;
.
.  I have a problem for approving event. Every time we approve event it
.  always index file GHH. Can we avoid this index ?
.
.  We use BPCS 6002 C/S plf cum March98 on AS/400 ver 3R7.
.
.  Thanks
.
.  Kusman Lim
.  PT Takeda Indonesia
.  MIS Department
.
.  +---
.  | 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
.  +---
.

+---
| 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
+---