[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

80.0. "FOCUS equiv for "REDUCED TO"" by EVOAI1::CHAPMAN () Tue Jun 21 1988 09:31

    
    	Does anyone know the focus equivalent for the datatrieve
    command

            REDUCED TO
    
    thanks in advance
    			geoff

T.R Title User Personal
Name Date Lines

80.1 Think FOCUS/Not DTR PLANIT::RYAN Thu Aug 04 1988 18:45 20

T.R	Title	User	Personal Name	Date	Lines
80.1	Think FOCUS/Not DTR	PLANIT::RYAN		`Thu Aug 04 1988 18:45`	20
	That's easy if you don't think like DTR. Anytime you use a 'by' statement you are 'reducing to' a sort level. So, any table request with by statements will reduce your data. At the simpliest level, issue: TABLE FILE xxx BY X BY Y END Don't even use a verb such as print or sum. Or if you want to use this construct: TABLE FILE xxx COUNT ENTRIES BY X END 'ENTRIES' is way FOCUS will count instances. -rpr-

    That's easy if you don't think like DTR.  Anytime you use a 'by'
    statement you are 'reducing to' a sort level.  So, any table request
    with by statements will reduce your data.  At the simpliest level,
    issue:  
    
    TABLE FILE xxx
    BY X 
    BY Y
    END
    
    Don't even use a verb such as print or sum.  Or if you want to use
    this construct:
    
    TABLE FILE xxx
    COUNT ENTRIES BY X
    END
    
    'ENTRIES' is way FOCUS will count instances.
    
    -rpr-