[Search for users] [Overall Top Noters] [List of all Conferences] [Download this site]

Conference ilbbak::ibi_focus

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

88.0. "FOCUS 5.2 bug - RDB join loops" by NRMLZE::ESTES () Wed Jul 06 1988 13:05

						focus_52_bug.txt

			*** FLASH *** 
      Focus join to RDB, available in Release 5.2, has a serious bug.

Problem Statement:

When joining a Focus database to a RDB database and the user selects 
 a Focus database element that has a MISSING occurance - Focus loops, 
 merging more and more records, forever.

 In a test of mine, when 7 records should have been returned, I killed it 
at "MERGE 19000 records"...  Tabletalk doesn't seem to report the "MERGE" 
message and just hangs.

Reporting of either Focus data or RDB data, with no join between the 
two works ok.

IBI IRN reference number is 1820139

IBI workaround:

Dump the data out of the Focus database and FIXFORM, Data element by 
data element, back in.  This will replace all missing data with a "0" 
value.  Note that this action may invalidate some arithmetic 
functions, such as average.  for example:
	

	PART	STD_COST_MISSING	STD_COST_ZERO
	VT100	$50.00			$50.00
	VT102	. (MISSING)		0
	
	     AVG IS $50			AVG IS $25
T.RTitleUserPersonal
Name		DateLines