[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

385.0. "TABLETALK WHERE Clause in V6.0" by AIMHI::FORMALARIE () Wed Dec 05 1990 16:54

    I hope this is operator error and not a bug in FOCUS 6.0
    
    I'm using TABLETALK to do a product report.  The first time
    thru i asked for all records and got a report that listed
    products in the SW, ZZ, etc product families.  When I use the
    WHERE clause to limit the report to products in the SW family,
    I get no records in my report.  The WHERE clause looks like
    
    WHERE PRODT_FAMILY_CODE EQ 'SW'
    
    TABLETALK built the command for me.
    
    -Anne
T.RTitleUserPersonal
Name		DateLines
385.1WHERE/IF Confusion ??OVAL::CARSEDThu Dec 06 1990 04:0114
    
    We don't have FOCUS V6.0 in Europe yet so I've no experience of the
    new WHERE statement (apart from reading the release notes) but, in your
    particular example, a simple IF statement should be suffice to produce
    the correct results i.e.
    
    		IF PRODT_FAMILY_CODE EQ 'SW'
    
    I believe the WHERE statement is used to compare the values in
    different fields on the database and not for testing against literals.
    
    Regards  -  David
385.2IF not available in TABLETALKAIMHI::FORMALARIEThu Dec 06 1990 08:017
    Hi David,
    Yes, IF will work fine, but we want to use TABLETALK and IF isn't
    available using TABLETALK.  WHERE looks like the means to do
    record selections.
    
    thanks for the reply.
    Anne
385.3WHERE incompleteCSS::PETROPHNoting Ten Times the Speed of LoveThu Dec 06 1990 13:1722
    
    Anne,
    
    The following TABLETALK generated FEX works;
    
	TABLE FILE A1
	SUM ORDER_QTY
	BY PN
	WHERE (ORDER_TYPE  EQ 'I');
	END
    
    This edited version doesn't;
    
	TABLE FILE A1
	SUM ORDER_QTY
	BY PN
	WHERE ORDER_TYPE EQ 'I'
	END
    
    
    	Rich...
385.4Edit TABLTALK.FEXAIMHI::FORMALARIEFri Dec 07 1990 14:449
    The problem seems to be with indexed files.  It has been reported to
    IBI FOCUS.  We're getting around it by creating the report in 
    TABLETALK and then editting it.
    
    Word is that WHERE will be removed from Version 6.1 in January.
    
    thanks for the help.
    
    -Anne