Converting from 7.10 F2 to 8.20 D

[Deskin, Bob]

As has been mentioned, it looks like this was something 7.10 let slip
through. QUICK can't handle occurrences within occurrences. In fact, you
wouldn't be able to process individual occurrences within the occurring
file. If the occurring item is a substructure, you might be able to override
what QDESIGN is trying to do by specifying an ITEM statement on the
containing item. I haven't tried this, so it may not work. Here's the idea.
In the dictionary you have:

ITEM X
  BEGIN STRUCTURE
    ITEM Y OCCURS 10
    END STRUCTURE 

And in QDESIGN use:

FILE F2 AUDIT OCCURS WITH F1 NOITEMS
  ITEM X OF F2 INITIAL X OF F1 FIXED

You'll probably need the NOITEMS to prevent QDESIGN from attempting the
automatic initialization generation. Unfortunately this means that you'll
have to do all the initialization yourself.

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: Odette McMillan [mailto:omcmilla@milk.org]
Sent: September 20, 2000 10:17 AM
To: Powerhouse Newgroup
Subject: Converting from 7.10 F2 to 8.20 D


I'm recently in the process of converting all quick, qtp and quiz programs
from 7.10 F2 to 8.20 D. The system we have is the Alpha (Open VMS).
I am currently experiencing a problem with re-compiling a Quick program. The
statement it is bombing on is:

FILE PRD_FILE_AUD AUDIT OCCURS WITH PRD_FILE

Bear in mind that file PRD_FILE also contains an item that is a table entry
(the item occurs 3 times). PRD_FILE_AUD contains the same items as PRD_FILE
with the inclusion of the audit items. The main file is defined as:

PRD_FILE DETAIL NOITEMS OCCURS 18 TIMES NODELETE

The error I'm receiving is this:
*E* Can't initialize the repeating item of the multiple occurring file
(PRD_FILE)

There are other Quick programs in our system, that use the same files, that
have successfully re-compiled to 8.20d. The difference with this particular
program is that the main file is defined as DETAIL with an OCCURS. (all the
other ones were defined as PRIMARY or SECONDARY but no occurs).

Can someone help, please!?

Thanks,

Odette McMillan
Senior Programmer Analyst
Dairy Farmers of Ontario

= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
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.