| 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 | 
I made this fex but am having certain problem with it. Can you look at it and tell me why it doesn't work the way I want it to. !TEST_ADD_MODIFY MODIFY FILE TEST_REP CASE START CRTFORM "THIS OPTION ADDS NEW RECORDS AND UPDATES EXISTING RECORDS </1" "Instructions: </1" "1. Enter data in following field" "2. Use TAB to MOVE cursor" "3. Press RETURN when finish " "4. To EXIT from the option PRESS PF1 </1" "Note: If record doesn't exist each fields displayed will be emptied" " If record exist data in each field will be displayed </1" "<10 Enter report name: <T.REPORT_NAME>" "<10 Enter frequency: <T.FREQ>" "<10 Enter username: <T.USERNAME> " MATCH REPORT_NAME ON NOMATCH TYPE " THIS RECORD WILL BE ADDED TO DATABASE..." ON MATCH TYPE " THIS RECORD ALREADY EXIST...RECORD CAN BE MODIFIED" ON MATCH/NOMATCH CRTFORM LINE 10 " REPORT DISTRIBUTION INFORMATION UPDATE </1" " --------------------------------------------------------------------------" "<.HD.REPORT_NAME <.HD.FREQ <.HD.USERNAME " " " " Desc: <T.DESC " " COM: <T.COM Step: <T.STEP " " Dest: <T.DEST Dept: <T.DEPT CC: <T.CC " " Qty : <T.QTY Ret. period:<T.RETENT_PER Ret. #: <T.RETENT_NO " " -------------------------------------------------------------------------" MATCH REPORT_NAME FREQ USERNAME ON MATCH UPDATE * ON NOMATCH INCLUDE ENDCASE DATA Look at what the program does! I am going to enter a new report name Enter Report Name: LINDA.RPT Enter Freq : D Enter Username : LINDA JOHNSON It display this next: It should have at display the key field (?) Display: ? ? ? Desc: STEP: COM: Dest: Dept: CC: Qty: Ret_period: Ret. #: Now I am filling in the fields ? ? ? Desc: THIS IS JUST A TEST STEP: 010 COM: AGO_TEST Dest: AGO13 Dept: IS CC: 631 Qty: 1 Ret_period: 28 Ret. #: JKF007 Now I want to recall what I entered. (would like for it to display again after I entered instead of taking me to the prompt field again. Enter Report Name: LINDA.RPT Enter Freq : D Enter Username : LINDA JOHNSON Now see displays this butw hat happen to the username,dept,cc,qty,ret period and ret. # there empty? LINDA.RPT D ? Desc: THIS IS JUST A TEST STEP: 010 COM: AGO_TEST Dest: AGO13 Dept: ? CC: ? Qty: ? Ret_period: ? Ret. #: ? But if I enter the field again then it will give me the display with the information in all the fields. Why is that? Now let say I want to enter a another user for the same report Enter Report Name: LINDA.RPT Enter Freq : D Enter Username : ALBA SOTO It will display me the last one I entered. LINDA.RPT D LINDA JOHNSON Desc: THIS IS JUST A TEST STEP: 010 COM: AGO_TEST Dest: AGO13 Dept: IS CC: 631 Qty: 1 Ret_period: 28 Ret. #: JKF007 I reenter the key fields again, display me the following: LINDA.RPT D ALBA SOTO Desc: THIS IS JUST A TEST STEP: 010 COM: AGO_TEST Dest: AGO13 Dept: ? CC: ? Qty: ? Ret_period: ? Ret. #: ? Why didn't it return the display with the fields empty, why only part of the fields were displayed as before? Can you help me with this problem? thanks lj
| T.R | Title | User | Personal Name | Date | Lines | 
|---|---|---|---|---|---|
| 288.1 | Try this! | EN::COYLE | Tue Dec 12 1989 15:33 | 41 | |
| 
    
  LJ,
     The reason it did not display the key fields in your first example
is that it is an add ( a nomatch condition) and therefore doesn't have
any data to display.  I think you can "activate" the field for display
by including the following:
   ON MATCH TYPE "THIS RECORD ALREADY EXISTS...RECORD CAN BE MODIFIED"
   ON NOMATCH COMPUTE
                       REPORT_NAME    = REPORT_NAME;
                       FREQ           = FREQ;
                       USERNAME       = USERNAME;
   ON MATCH/NOMATCH CRTFORM LINE 10
             .
             .
             .
  
   It is also recommended that you use conditional fields (one carat)
for data entry fields and conditional fields (2 carats) for turnaround fields.
Therefore, in your example I would change the entry fields to:
"<10   Enter report_name:  <REPORT_NAME  "
"<10   Enter frequency  :  <FREQ         "
"<10   Enter Username   :  <USERNAME     "
   and the turnaoround fields to (EX: Desc: <T.DESC>).
One other question is why your first match doesn't have the three fields
that are included in the second match.  I believe FOCUS will assume they are
there, if in fact, you have an S3 in your master file.
                            Hope this helps 
                              Kevin             
 | |||||
| 288.2 | Re-entering twice to get full display | CORREO::REPDIS | Wed Dec 13 1989 08:35 | 5 | |
|     First thanks for giving attention to my problem. The displays work
    fine now but when I enter for the first time and then reenter it
    doesn't display the rest of the other fields but if I call it again
    then it will. Why is that?
    
 | |||||
| 288.3 | Master File Description? | EN::COYLE | Wed Dec 13 1989 10:09 | 16 | |
|     
    
      Not Sure,
    
        Can you include a copy of your master file description?  Or mail it
    to me.
    
                                              Thanks,
         
    
                                                KC
                                               
    
    
    
                                      
 | |||||