| T.R | Title | User | Personal Name
 | Date | Lines | 
|---|
| 482.1 | FOCEXTRACT | EVTDD1::CARRIERE | Jean-Claude Carriere | Wed Nov 20 1991 03:22 | 22 | 
|  | Dear Stuart,
	Well, I cannot say much about your first problem, except I don't
	recall any limit in FOCUS for this, aside from VMS directory/filename
	length limit.
	One thing I may suggest would be to create a concealed logical name
$assign/trans=conceal DISK$DECLOTEXT:[CMTPROD.LOTEXT_DAILY_REPORTS.] disk$appl
and then work from disk$appl:[LOTEXT_FREQUENT]
	However regarding the .DOC file, there is s SET FOCEXTRACT command
	(TEMPORARY or DEFAULT) which let's you specify where you want your
	extract file to be saved. In the case where you use /SUBDIR=DELETE
	you should SET FOCEXTRACT=DEFAULT whenever you want to keep the file.
	Note : SET FOCEXTRACT=TEMPORARY is the default
	(To shed some light on the subject, this behavior was introduce
	after multo discussions at IBI ... to accomodate the ALLIN1 interface
	and allow a more flexible access to folders.)
Jean-Claude
 | 
| 482.2 |  | HAMSTR::BAMFORTH |  | Wed Nov 20 1991 12:43 | 14 | 
|  |     
    To avoid having to frequently reset FOCEXTRACT in a multi-step process, 
    
    include the following only in the request whose output you want
    directed to the default directory. 
    
    ON TABLE SET FOCEXTRACT DEFAULT  
    
    
    Note: This in only in effect for this "step", preceding/subsequent
          steps get directed to your temporary directory (if you used 
          FOCUS/SUBDIR=DELETE ) 
    
    jb
 | 
| 482.3 | If I could only read the manuals cover-to-cover | KAHALA::FOREMAN | Nothings Impossible, you just run out of time | Thu Nov 21 1991 10:04 | 20 | 
|  |     re : .2 ON TABLE SET FOCEXTRACT DEFAULT
    
    I was mildly aggravated by the change putting format DOC files in
    the temporary directory.  Not knowing about the above I've been
    simply doing VMS copies from the Temporary directory to my
    storage directories.  Most of the work done in my FOCUS sessions
    is "temporary" so I didn't want to discontinue using the SUBDIR=DELETE
    feature.  I'm unclear how to use the feature mentioned above.  Is
    this documented in the manuals ?  If not would this statement be
    placed prior to the TABLE FILE request that creates my DOC file
    and then become inactive after another TABLE FILE request is
    issued ? *OR*
    Is this an additional ON TABLE line added to the body of my
    TABLE FILE request ?
    
    Thanx for your input - this seems like a cleaner way to save what
    you want in a SUBDIR=DELETE session.
    
    Sharon
    
 | 
| 482.4 | Dynamic SET usage. | HAMSTR::BAMFORTH |  | Thu Nov 21 1991 12:03 | 43 | 
|  |     
    Sharon,
    
    This type of dynamic variable setting is mentioned in the V6.0+
    features.  Rather than statically setting parameters, you can 
    dynamically set them for the current table request, while the
    default values will apply on prior/subsequent requests. 
    
    An example:   
    
    GIVEN: FOCUS ENTERED VIA FOCUS/SUBDIR=DELETE 
    
    
    TABLEF FILE MASSIVEDB 
      PRINT A B C 
      IF YR EQ '91' 
      IF MO IS-FROM 10 TO 12  
    ON TABLE HOLD AS EXTR92Q4 
    END
    -RUN
    
    TABLE FILE EXTR92Q4  
    " "
    " EXAMPLE" 
    " "
    SUM B  
        C  
    BY  A   
    
    ON TABLE SET LINES 62,PANEL 500,FOCEXTRACT DEFAULT 
    ON TABLE HOLD AS YOURRPT FORMAT DOC 
    END
    -RUN 
    
    
    The only file retained (on your default DIR) in the above case would be
    the YOURRPT.DOC  
    
    jb 
    
    
    
    
 | 
| 482.5 | Handy item | KAHALA::FOREMAN | Nothings Impossible, you just run out of time | Thu Nov 21 1991 13:59 | 8 | 
|  |     Thanx for the clarification.  I did find it in my 6.1 manuals ( Vol I,
    Page 2.147 if anyone's interested ).  Amazing how quickly you can find
    things when you already have the answer ;-)
    
    This is a handy bit of functionality - this notesfile is so
    enlightening.
    
    Thanx again
 |