Problem with Qtp/Subfile/Item...Minimum

[Mike Palandri]

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