For Missing Question

[Deskin, Bob]

I gather you mean why does the GET in the FIND work but not in an INTERNAL.
That's because a GET in a FIND (or DETAIL FIND) is special. It retains the
position in the file and does a GET NEXT regardless of whether the procedure
is called again. This will happen when you see the first group of records
and then get the next group. Outside of these two procedures, the GET always
does a GET FIRST after you finish the procedure. So while it may read down a
chain within a FOR loop inside an INTERNAL, once you go back to the user and
subsequently call the procedure again, it will start over at the beginning.

Bob Deskin              
PowerHouse Web Product Manager and Senior Product Advisor
Application Development Tools, Cognos Inc.
bob.deskin@cognos.com (613) 738-1338 ext 7268 FAX: (613) 727-1178
3755 Riverside Drive P.O. Box 9707 Stn. T, Ottawa ON K1G 4K9 CANADA


-----Original Message-----
From: Terry Pickering [mailto:pickering@myself.com]
Sent: November 9, 2000 12:49 PM
To: powerh-l@sphere.swau.edu
Subject: For Missing Question


Chris asked if "multiple wps-po-mst records per gls-po-driver record" was 
the case. No, they are one-to-one. What I don't understand is why if I am 
not using GLS-PO-DRIVER everything works fine. If the screen was changed to 
the following it works just fine. It will continue displaying records way 
past the 255.

Also, if I remove the CACHE clause, it only displays one screen of data 
since by default it sets the cache to the number of occurrences.

Bob - why does this example work, but the previous one does not??? Also, is 
there another way than what I tried using the GLS-PO-DRIVER file as a 
designer file to accomplish the same thing. Basically, I want to read the 
GLS-PO-DRIVER file and link to the WPS-PO-MST file to display them. They 
are a one-to-one relationship. I'm also going to take a closer look at 
Chris' suggestion.

Here is the example of code that works just fine.



SCREEN GLS_EXE:TPK016  ACTIVITIES FIND

FILE WPS-PO-MST PRIMARY    OCCURS 14 CACHE 20

TEMP T-VENDOR-NUM CHAR*10 RESET AT STARTUP

FIELD T-VENDOR-NUM

CLUSTER OCCURS WITH WPS-PO-MST
ALIGN (1,,1) (10,,10)
FIELD PO-NUM OF WPS-PO-MST SIZE 6
FIELD CUSTOMER-NUM OF WPS-PO-MST
;*********************** PROCEDURES ***************************

;************************
PROCEDURE PATH
;************************
BEGIN
   REQUEST T-VENDOR-NUM
   LET PATH = 1
END

;************************
PROCEDURE FIND
;************************
BEGIN
    FOR MISSING WPS-PO-MST
       BEGIN
         GET WPS-PO-MST VIA VENDOR-NUM USING T-VENDOR-NUM
       END
END


Terry Pickering
Eugene School District 4J
(503) 687-3416


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