Focal Point
[SOLVED] Bewildering situation with the WHERE clause

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

June 05, 2009, 09:24 AM
Martin_fmi
[SOLVED] Bewildering situation with the WHERE clause
Hi everybody,
I encounter the following situation from time to time (and I can't answer myself why is it happening):
I have for example
TABLE FILE
PRINT *
WHERE AND
ON TABLE HOLD AS
END
-RUN

and the holdfile must have 160 rows e.g. , but it happens to be 152.
Adding a
DEFINE FILE
END
-RUN
(with no defined fields inside)
gives the desired 160 rows ( which is the correct output ). Can somebody tell me why is that happening ? Thanks in advance.

This message has been edited. Last edited by: Kerry,


WF 7.6.5 / OS: XP / FOCUS
June 05, 2009, 10:06 AM
Martin_fmi
Sorry , I found what is happening Smiler I just had a DEFINE FILE many rows above and one of the columns in the WHERE cluase was changed in it ...


WF 7.6.5 / OS: XP / FOCUS