[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 I just had a DEFINE FILE many rows above and one of the columns in the WHERE cluase was changed in it ...