Problem with Qtp/Subfile/Item...Minimum

[Richard Witkopp]

If maximum works, you could change it into a number and
multiply by -1. Be sure to switch it back in the next qtp/quiz
pass, or create another field with it in original for to use.

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