Conference ilbbak::ibi_focus

203.0. "Focus Hang in 5.2 and 5.2.1, when joined to Rdb" by NRMLZE::ESTES () Thu Apr 20 1989 11:15

Focus 5.2/5.2.1 hang when Focus and Rdb Joined.

  I have found that Focus will hang under two situations when a Focus
  database is joined to a Rdb database.

  1. Printing a Rdb field and a Focus field when the focus field is
     "Missing" from the database.  

     Example of Missing display:

		  TABLE FILE FOCJRDB
		  PRINT FOCFLD_1 FOCFLD_2
		  END			
		
		FOCFLD_1   FOCFLD_2
		
		  XXXX	     .

     Example of Focus hang:

		  TABLE FILE FOCJRDB
		  PRINT FOCFLD_2 RDBFLD
		  END			
   
		   focus hanging...				  

     Workaround:  I wrote a Focus Fex to traverse the database testing
                  for missing segments and including them when found.
		  
     Note: I reported this problem when Focus 5.2 was released.  They
           promised to fix it, but obviously did not.

  2. Testing a Focus field that happens to be in the first unique segment
     of the Focus database, when joined to Rdb.

     Example:
     using the following FOCMAS:
	SEGMENT=BADGESEG, SEGTYPE=S1, PARENT= ,$
	  FIELD=BADGE        ,BADGE       ,I6    ,FIELDTYPE=I,$
	SEGMENT=BASEINFO, SEGTYPE=U, PARENT=BADGESEG, $
	  FIELD=BASE_CC      ,BCC         ,A3    ,TITLE='BAS,CC'        ,$
          (more fields....)
	(other segments...) 	
 
    And issuing the command:
	JOIN BADGE IN FOCMAS TO RDBFLD IN RDBMAS
 
    Then printing using a test on a focus field in the first unique segment:

	TABLE FILE FOCMAS
	PRINT BADGE RDBFLD
	IF BASE_CC EQ '6AT'
	END

	Causes Focus to hang.....

    Testing on fields in other segments, unique or not, works ok.