QDESIGN file types and cluster control (PH607F on AS/400)

[David Morrison - Corporate]

Daniel,

1. Use the HOLD FIND.
2. Why not make your file a primary file instead of a detail file?

David Morrison

 -----Original Message-----
From: 	Daniel Mielke [mailto:DMielke@aic.com] 
Sent:	Wednesday, May 01, 2002 10:58 AM
To:	Powerhouse List (E-mail)
Subject:	QDESIGN file types and cluster control (PH607F on AS/400)

Hi Listers,

I'm getting some weird results when building a FIND only screen.

Bear with me on this example(Once again, thanks Chuck!):

I want to list the detail of RATLET-RACES for active RATLETS.  The user is
coming into the screen with a RAT record as MASTER.  RATLETS is being
retrieved via ratlet-status and selected if rat-no of RAT = rat-no of
RATLETS.  RATLET-RACES is a DETAIL file indexed by ratlet-no (matching up to
RATLET).  The cluster is based on the occurrence of RATLET-RACES.

There are three active RATLETS.  Each RATLETS record has matching
RATLET-RACES records.  However the screen displays only two RATLETS and
stops.  The scrolling back doesn't work.  When the HOLD FIND is removed, the
scrolling back works and gets the third RATLETS record and associated
RATLET-RACES records.  

The impression that I get is that QUICK is passing once though RATLET-RACES.
QUICK finds RATLET-RACES for the first RATLETS record, continuing on from
that point to get records for the second RATLETS record, and stopping when
it can't find RATLET-RACES records for third. (RATLETS is not being
retrieved in ratlet-no order)

Is there a way to ?Reset? the access of the detail file for each occurrence
of RATLETS?

Should I change the file structure?

Help! 

> BUY. HOLD. AND PROSPER.
> 
> Daniel Mielke
> Business Systems Analyst
> AIC Limited
> 1-888-710-4242 (4614)
> dmielke@aic.com
> www.aic.com
> 
> 

= = = = = = = = = = = = = = = = = = = = = = = = = = = =
Mailing list: powerh-l@lists.swau.edu
Subscribe: "subscribe" in message body to powerh-l-request@lists.swau.edu
Unsubscribe: "unsubscribe" in message body to
powerh-l-request@lists.swau.edu
http://lists.swau.edu/mailman/listinfo/powerh-l
This list is closed, thus to post to the list you must be a subscriber.