| 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: 12394
 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 |  | 
	
		|  | 
	
		|  | 
	
		|  |