Hi, I am a new developer in the webfocus and we have webfocus 762.
I have a problem running a report, after runnig a report i get an error as
'(FOC1070) VALUE FOR JOIN 'FROM' FIELD OUT OF SEQUENCE. RETRIEVAL ENDED'
without a line # mentioned in the error.
The join is of 2 Holf Files.
Let me out few lines of code here,
-*------------------
JOIN
INNER
GL_TRANS_TEMP.MASTER_ACCT IN GL_TRANS_TEMP TO GL_BALANCES.MASTER_ACCT IN GL_BALANCES AS JX2
END
-*------------------------
TABLE FILE GL_TRANS_TEMP
PRINT
AMT
BEGIN_BAL
END
-*---------------
i m getting the error here.
Can anybody put some light on this.....
Thanks in advance
Gauri

quote:

JOIN
INNER
GL_TRANS_TEMP.MASTER_ACCT IN GL_TRANS_TEMP TO GL_BALANCES.MASTER_ACCT IN GL_BALANCES AS JX2
END

When joining files, they both must have the same sequnce or index order, if not you will get the error.

Leah,
the index fields are in sequence. I am still getinng the error.

Leah is correct. Unless the HOLD files were created with a special output type, they are just flat files. Both files must be sorted by the MASTER_ACCT field.

The MASTER_ACCT description in the masters for each file must have the same format.

Please double check this.