View previous topic :: View next topic |
Author |
Message |
uneasabe Beginner
Joined: 26 Oct 2003 Posts: 8 Topics: 4 Location: Mumbai
|
Posted: Thu Feb 19, 2004 12:20 am Post subject: FOCUS- VACHYTD and VACENYTD |
|
|
hi,
I have a sample code in focus
TABLE FILE ER03
SUM HRSRYTD VACHYTD ABPYTD
ERNRG_YTD VACENYTD ABYTD
BY LSTNM
BY FSTNM
BY SSN
BY EST
BY WB
-* PM EQ 14
-* PR EQ 460 OR 463
-* WB EQ L33
IF WB EQ L33 OR L34 OR L35 OR L36
ON TABLE SAVE AS 'LT10'
END
I would like to know if VACHYTD and VACENYTD are key words, and if they are then what do they stand for and what are their functionalities?
Also if anyone can understand what exactly the code is doing?
Thanks a lot
Sabeeka |
|
Back to top |
|
|
kolusu Site Admin
Joined: 26 Nov 2002 Posts: 12376 Topics: 75 Location: San Jose
|
Posted: Thu Feb 19, 2004 6:19 am Post subject: |
|
|
Uneasabe,
Even though I have never worked on focus it is so obvious by looking at the code that VACHYTD & VACENYTD are both fields defined in your program and they are performing a sum on those fields. They are not keywords
You are summing the fields HRSRYTD, VACHYTD, ABPYTD, ERNRG_YTD, VACENYTD, ABYTD for every LSTNM(lastname??) FSTNM( first name??) SSN(Social security Number??) EST(??) & WB(??)
All the above colums are fields in your file
In the other post you have asked for focus manuals and if you have spend at least 10 mins reading that manual you would have answered this question yourself.
Thanks
Kolusu _________________ Kolusu
www.linkedin.com/in/kolusu |
|
Back to top |
|
|
uneasabe Beginner
Joined: 26 Oct 2003 Posts: 8 Topics: 4 Location: Mumbai
|
Posted: Thu Feb 19, 2004 7:04 am Post subject: |
|
|
kolusu,
yes i did figure out that the code would be doing something like that, but its not behaving as it should, Also was unable to locate the structure of the mentioned variables which made me wonder if they were keywords or not.
Anyways thanks a lot for your help, i need it a lot since FOCUS is very new to me
uneasabe |
|
Back to top |
|
|
hari_uss Beginner
Joined: 19 Dec 2002 Posts: 78 Topics: 6 Location: Trivandrum, India
|
Posted: Sat Feb 21, 2004 12:58 pm Post subject: |
|
|
Sabeeka,
Quote: |
Also was unable to locate the structure of the mentioned variables which made me wonder if they were keywords or not.
|
Where were you looking at? MFDs? It is not necessary that the fields should be defined there. It can be something that is defined within the program. Please check. |
|
Back to top |
|
|
|
|