Sequential Period generator?

[Chris Coukell.]

Hi Martyn,

The simplest way that I can think of is to use multiple output statements, 
one for each period in the range, with a condition put on each of the 
output statements that determines if the period being written is within the 
range.  A temporary field would need to be maintained after each output to 
increment the period 'counter'.

Regards,

Chris

-----Original Message-----
From:	Thomson, Martyn EDUC:EX [SMTP:martyn.thomson@gems1.gov.bc.ca]
Sent:	Tuesday, August 01, 2000 2:00 PM
To:	'POWERHOUSE Listserv'
Subject:	Sequential Period generator?

Hello all
Can anybody suggest a simple QTP strategy to accomplish the following -

I have a table UWI_RANGE which contains an Id field, and start and end
periods in the format YYYYMM -char(6).

I need to populate another table UWI_PERIODS which contains the same ID
field and a PERIOD char(6) - creating one record for each month in the 
range
for the ID.  Currently this is done by a 'while retrieving' loop in a batch
Quick screen, but I would like to rewrite it in QTP.

There is another table DB_PERIODS available which contains a field 
DB_PERIOD
char(6) and has a row for every period ever used. Perhaps this can be 
linked
to in some way and a SELECT statement used to limit the transaction set to
the period range?
Any help with this much appreciated.
Martyn


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