Problem with Qtp/Subfile/Item...Minimum

[Robert Mills]

Thanks for the try Mike. Your suggestions don't work because a) sort item is
required by 'Reset At key-item' on the temporary's (an *E* is generated) and
b) adding sort to DATE-GOODS-REC makes no difference.

Thanks for the idea Glenn but that was discarded right from the start. The
record is too big for Quiz.

I finally got a reply from Cognos UK and it looks as if there has been a BUG
in the Minimum option since 709 (also in the Vax version). If you replace it
with Maximum it will work. Have an idea on how to 'skin this cat' and will
post the results if it works.

-----Original Message-----
From: Glenn Waters [mailto:Glenn_Waters@ncsu.edu]
Sent: Tuesday, August 08, 2000 1:20 PM
To: powerh-l@sphere.swau.edu
Subject: Re: Problem with Qtp/Subfile/Item...Minimum


Just a minor suggestion. Sometimes when I have trouble getting QTP to
cooperate making a subfile, I fall back on making it through Quiz. Yeah I
know, its not as efficient for big chunks of data, but "sometimes" its a
little easier to work with (when creating subfiles..).  



At 05:09 AM 8/8/2000 -0700, you wrote:
>I have just been working with some similar code, but the TEMP statements
follow ACCESS and preceed SORT,  I don't know if that makes a difference.  
>
>Do you perhaps need to sort on DATE-GOODS-REC Of detail-set as well?  IT
seems like this would make it easier for QTP to determin the minimum in each
key-item Of detail-set  control group.
>
>
>At 11:30 AM 08/08/2000 +0100, Robert Mills wrote:
>>Can someone tell me why the following bit of Qtp code does not work?
>>
>>> Access detail-set                                                  &
>>>   Link key-item              Of detail-set                         &
>>>     To key-item              Of master-set                         &
>>> 
>>> Sort                                                               &
>>>   On key-item                Of detail-set  
>>> 
>>> Temporary t-RETURN-DATE      Character *8
>>>      Item t-RETURN-DATE      Minimum DATE-GOODS-REC Of detail-set  &
>>>                              Reset At key-item Of detail-set
>>>
>>> Subfile CM000EX3             At key-item Of detail-set             &
>>>                              Keep                                  &
>>>   Include                                                          &
>>>     key-item                 Of detail-set,                        &
>>>     t-RETURN-DATE                                                  &
>>>   Index key-item             UNIQUE                                &
>>>     Segment key-item  
>>
>>The item DATE-GOODS-REC is a char 8 field and holds the date in CCYYMMDD
>>format. Some records do not have a date but most record do.
>>
>>The value returned in the subfile item t-RETURN-DATE is 'FF FF FF FF 20 20
>>20 20' in hex. That is 4 high-value characters and 4 space characters.
>>
>>We're running 819C5 under MPE/iX 6.0 if that helps anybody.
>>
>>Regards,
>>Robert
>>
>>+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-
+
>>|Robert W.Mills (Senior Analyst/Programmer) |    >>>> Please Note <<<<
|
>>|Windsong Services, St. Mary Cray, ENGLAND  |The opinions expressed above
|
>>|Tel  : +44 (0)1689 870622 x3005            |are my very own and NOT
those|
>>|Fax  : +44 (0)1689 899026                  |of my employer. They are
thus|
>>|Email: Robert.Mills@windsong-services.co.uk|subject to change or
complete|
>>|URL  : www.windsong.co.uk                  |reversal without any notice.
|
>>+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-
+
>>= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
=
>>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.
>>
>
>Mike


Glenn Waters
North Carolina State University 
College of Veterinary Medicine 
4700 Hillsborough St., Box 8401 
Raleigh, NC 27695-8401 
Phone: (919) 513-6652
Fax: (919) 513-6452 
Email: Glenn_Waters@ncsu.edu


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