quick screen

[Johnson, Harold A EDUC:EX]

Just from your sample, I was assuming that the key on the file was based on
something simple, such as the yr and prt code, whatever that is.  Here is a
sample program that I whipped together illustrating the concept.  Depending
on your keys and logic, you can perhaps do something similar.

cheers


ie: 

source table:

CTM_ID        CTD_CODE

LOS           1              
LOS           2              
LOS           3              
LOS           4              
LOS           5              
LOS           6              
LOS           7              
LOS           8              


-------------------------
sample program:

cancel clear
screen harry
file ctd in sfas_database primary occurs 10
 access         via ctm_id using "LOS"

file ctd in sfas_database alias ctd2 reference occurs with ctd
 access         via ctm_id, ctd_code  &
                using ctm_id of ctd, &
                      ascii(nconvert(ctd_code of ctd) - 1)

define d_code1 char*10 = ctd_desc_text of ctd
define d_code2 char*10 = ctd_desc_text of ctd2

align (,,1) (,,15) (,,30) (,,45) (,,60)
cluster occurs with ctd
field ctm_id of ctd
field ctd_code of ctd
field d_code1
field ctd_code of ctd2
field d_code2
cluster


-------------------
Resulting output:

MODE:F ACTION:         
LOS           1              Non-Degree     0              ~
LOS           2              Co-op Non-     1              Non-Degree
LOS           3              Undergradu     2              Co-op Non-
LOS           4              Co-op Unde     3              Undergradu
LOS           5              Masters        4              Co-op Unde
LOS           6              Doctorate      5              Masters
LOS           7              Diploma        6              Doctorate
LOS           8              Certificat     7              Diploma

 

-----Original Message-----
From: powerh-l-admin@lists.sowder.com
[mailto:powerh-l-admin@lists.sowder.com]On Behalf Of terry terry
Sent: 2005 April 26 1:40 PM
To: powerh-l@lists.sowder.com
Subject: quick screen


Hi
     can you give me  a rough sample of the source code to link to the 
reference file to accomplish this as this is done per claimant each having a

different  reference number and a different set of years and also the  
formular for the fist half is different to the second half of the year 
.Incidentally the calculations are performed immediately as the amount for 
the year is entered .



reference to :
You could possibly add a reference file that occurs with the primary
cluster, keyed on data that points back to the previous year for each line.

ie: line 2 with yr=71 and prt=2 can reference the reference file as yr=72
and prt=1, etc..

_________________________________________________________________
On the road to retirement? Check out MSN Life Events for advice on how to 
get there! http://lifeevents.msn.com/category.aspx?cid=Retirement

-- 
= = = = = = = = = = = = = = = = = = = = = = = = = = = =
Mailing list: powerh-l@lists.sowder.com
Subscribe: "subscribe" in message body to powerh-l-request@lists.sowder.com
Unsubscribe: "unsubscribe <password>" in message body to
powerh-l-request@lists.sowder.com
http://lists.sowder.com/mailman/listinfo/powerh-l
This list is closed, thus to post to the list you must be a subscriber.