Any ideas on the following output from my code, I am baffled...

Thks,

Vipul


TABLE FILE PD_INFO
-*PRINT CNT NOPRINT
PRINT *
WHERE DEBITCREDIT EQ 'C'
WHERE BNKACCTKY IN FILE BAIFLTR
WHERE BNKACCTKY = 999
IF RECORDLIMIT EQ 1
ON TABLE HOLD AS ERRCREDIT
END
-*
-IF 1 EQ 0 THEN GOTO ERRCREDIT;
0 NUMBER OF RECORDS IN TABLE= 9 LINES= 1

0 HTML FILE SAVED ...


0 NUMBER OF RECORDS IN TABLE= 0 LINES= 0

-IF 0 EQ 0 THEN GOTO ERRCREDIT;

This message has been edited. Last edited by: <Mabel>,

yup, you need a -RUN after your fex part.
ON TABLE HOLD AS ERRCREDIT
END
-RUN
-IF &LINES EQ 0 GOTO ERRCREDIT;
remember, dialog manager commands execute FIRST, before any regular focus commands.
The way to force the fex to run before the &LINES is measured is to put a -RUN after the fex. Then your &LINES will execute AFTER, and you'll actually have something to count.

Yes, -RUN is necessary in this case between TABLE (stacked and not executed until -RUN is found) and -TYPE (Dialogue Manager command executes first in this case).

Regards,
Mikel

So very stupid of me. Thanks Mikel and Susannah.

Vipul