Conference ilbbak::ibi_focus

409.0. "version v6.0" by GERBIL::IMFRA () Thu Mar 28 1991 23:07

    
    FYI,
    
    A couple of really nice features of FOCUS V6.0: 
    
    * one can create FOCUS files from any TABLE request 
    
      table file gl91
      sum actl_expend 
      by cost_ctr 
      on table hold as gl91extr format focus index cost_ctr
      end
    
    * the other nice feature is a join based on a virtual field. 
    
    join edit_1_3 with cost_ctr in gl91 to cc in cost_ctr as j1 
    
      define file gl91
      edit_1_3/a3 = edit(cost_ctr,'999'); 
      end
     
    
      table file gl91 
      etc, etc, etc...
    
      note that one must associate a virtual field (edit_1_3) with 
      a real field (cost_ctr).
    
    
    
      One particularly powerful application of the the new "format foc"
      option is to create a .FOC file from a flat file when one wants to
       join to it.  Since you can create an index as needed in the XREF
      file, you need not woory about the error which is normally assoc.
      with joining to a flat (non-indexed) file, e.g. from- field out of 
      sequence.  
    
      Good luck !
    

    Thanks for pointing out those useful new features.
    -richard