[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

225.0. "FOC1071 'TO' FIELD OUT OF SEQ ???" by COGVAX::CLIFFORD () Thu Jun 22 1989 10:58

    I think I have a join problem using FOCUS.  I joined three
    files together with the commands:
    
    
JOIN CLEAR *
JOIN CC1 IN Q1 TO ALL CC2 IN Q2 AS JJOIN
JOIN CC2 IN Q1 TO ALL CC3 IN Q3 AS JB
                                    
    
    I do a check file picture and it is a linear join with Q1
    as the root, but when I try to do a report I get the message:
    
    FOC1071 'TO' FIELD OUT OF SEQUENCE
    
    Can anyone see something wrong?
                                                             7

T.R Title User Personal
Name Date Lines

225.2 just an idea (2) FERNEY::OTT Fri Jun 23 1989 07:47 13

T.R	Title	User	Personal Name	Date	Lines
225.2	just an idea (2)	FERNEY::OTT		`Fri Jun 23 1989 07:47`	13
	Sorry, I had a problem during the writing of .1, so I re-enter it. > JOIN CC1 IN Q1 TO ALL CC2 IN Q2 AS JJOIN > JOIN CC2 IN Q1 TO ALL CC3 IN Q3 AS JB I don't really know, but I would try: JOIN CC2 IN Q2 TO ALL CC3 IN Q3 AS JB JOIN CC1 IN Q1 TO ALL CC2 IN Q2 AS JJOIN JD.

  Sorry, I had a problem during the writing of .1, so I re-enter it.

> JOIN CC1 IN Q1 TO ALL CC2 IN Q2 AS JJOIN
> JOIN CC2 IN Q1 TO ALL CC3 IN Q3 AS JB

  I don't really know, but I would try:

 JOIN CC2 IN Q2 TO ALL CC3 IN Q3 AS JB
 JOIN CC1 IN Q1 TO ALL CC2 IN Q2 AS JJOIN

JD.