Problem with Qtp/Subfile/Item...Minimum

[Glenn Waters]

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.