Focal Point
(FOC774) THE WORD 'IN' MUST APPEAR IN A VALID CLAUSE

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/8841010242

August 15, 2007, 08:08 AM
FrankDutch
(FOC774) THE WORD 'IN' MUST APPEAR IN A VALID CLAUSE
I get this message when I run this little program

what's wrong

DEFINE FILE TBLMUTKV
JAAR/YY=DAG;
END
TABLE FILE TBLMUTKV
BY     FONDNR
WHERE BV_DAG GE 92420;
WHERE KLASSE EQ '';
ON TABLE HOLD AS HNOKLAS FORMAT ALPHA
END
-RUN
DEFINE FILE BA_FONDS

END
TABLE FILE BA_FONDS
PRINT
     FONDNR
     NAAMF
     KLASSE
WHERE FONDNR IN FILE HNOKLAS;
ON TABLE NOTOTAL
ON TABLE SET HTMLCSS ON
END





Frank

prod: WF 7.6.10 platform Windows,
databases: msSQL2000, msSQL2005, RMS, Oracle, Sybase,IE7
test: WF 7.6.10 on the same platform and databases,IE7

August 15, 2007, 08:30 AM
RichH
Hi Frank,
Blank records in the file can cause this error.
Rich


WebFOCUS 8202 Win 2012
Test - WebFOCUS 8203 on Win 2012
August 15, 2007, 09:33 AM
Brian Suter
Fixed in 760 and above.


Brian Suter
VP WebFOCUS Product Development