[Search for users] [Overall Top Noters] [List of all Conferences] [Download this site]

Conference ilbbak::ibi_focus

Title:	FOCUS, from INFORMATION BUILDERS

Moderator:	ZAYIUS::BROUILLETTE

Created:	Thu Feb 19 1987
Last Modified:	Mon May 05 1997
Last Successful Update:	Fri Jun 06 1997
Number of topics:	615
Total number of notes:	1779

68.0. "ACROSS fieldname COLUMNS" by MSBIS1::BICKFORD () Fri May 13 1988 15:24

    As an inexperienced user, I'm having a problem with a simple report
    that I have been trying to write.
    
    This works ok:   TABLE FILE BUDGETS
    	 	     PRINT C_INV_DOL
    		     ACROSS QTAPP
    		     BY DESC_INFO
    
    But when I add the ACROSS fieldname COLUMNS value AND value 
    (ref Vol 1, FOCUS VAX/VMS USERS MANUAL, p.2-37) no records
    are found.
    		TABLE FILE BUDGETS
    		PRINT C_INV_DOL
    		ACROSS QTAPP COLUMNS 1 AND 2 AND 3 AND 4
    		BY DESC_INFO
    
    I can't figure out WHY it WON'T work.........
    
    Thanks,
    Connie

T.R	Title	User	Personal Name	Date	Lines
68.1	answer	USWAV8::SAUNDERSDEV		`Tue May 17 1988 11:39`	6
	When using the command COLUMNS the values entered must correspond to data values of the field in the ACROSS statement. For example ACROSS TEST COLUMNS N1 AND N2 AND N3 AND N4 will work only if N1, N2, N3, and N4 are values found in TEST. Also, if TEST is an alpha field the values need to be in single quotes.
68.2	still doesn't work	MSBIS2::BICKFORD		`Tue May 17 1988 14:29`	9
	Thanks for the response. However, 1, 2, 3 and 4 are actual values in the field QTAPP and the field is define as I1 not alpha. Any further suggestions??? Connie
68.3	Try Quotes	SCRUZ::PARKER_TY	Tyrone Parker WR03-2/M13	`Thu Nov 10 1988 17:30`	10
	You might try enclosing the values in quotes even though they are defined as integer. FOCUS has a funny way about it with ACROSS and it has been a matter of TRIAL and ERROR with me. Tyrone.