Conference ilbbak::ibi_focus

114.0. "RDB and FOCUS ERR(FOC1453)" by MEMV03::LAVOIE () Wed Aug 17 1988 15:21

    I am using FOCUS with RDB and I am recieving the following message
    when I try to run a report from the following .MAS and .ACX files.
    I used the CHECK command to see if the segments were joined and
    they are.  I do not want to use the JOIN command and would like
    to define all segments in one master file using PARENT to join
    the relations, but I can not seem to get it to work correctly.
                                                          
    The ERROR MESSAGE 
    
     (FOC1453) IXFLD NOT IN CURRENT SEGMENT  :  PROJSUMM/PROJECT_ID
    
    
    The following is the .MAS 
    
    FILENAME=LRP, SUFFIX=RDB
    SEGNAME=LRP,  SEGTTYPE=S0
     FIELD=PROJECT_ID  ,ALIAS=PROJECT_ID  ,USAGE=A8    ,A8   ,$
     FIELD=LOCATION    ,ALIAS=LOCATION    ,USAGE=A3    ,A3   ,$
     .
     .
     .                        
    SEGNAME=PROJSUMM, SEGTYPE=S0, PARENT=LRP
     FIELD=PROJECT_ID  ,ALIAS=PROJECT_ID  ,USAGE=A8    ,A8   ,$
     FIELD=CHART_FLAG  ,ALIAS=CHART_FLAG  ,USAGE=A1    ,A1   ,$
     .
     .
     .
    
    
    The following is the .ACX
    
    SEGNAME=LRP, TABLENAME="LRP.LRP_FORCAST"
      KEYS=0,WRITE=NO,$
     FIELD=
     .
     .
     .
    
    SEGNAME=PROJSUMM, TABLENAME="PROJSUMM.PROJECT_SUMMARY"
      KEYS=0, WRITE=NO, KEYFLD=PROJECT_ID, IXFLD=PROJECT_ID ,$
     FIELD=
     .
     .
     .
    
          Any help will be appreciated.
    
                                            Thanks,
                                                      Liz.
    
    
    
    

    Hello
    
    	you can not use twice the same field name PROJECT_ID.
    
    	Change it in the .MAS and .ACX .
    
    					Best Regards Maurizio.