Example, I have a fex that returns rows and upon completion jumps to an html page for further processing. Sometimes no rows are returned.

I'd like to evaluate the number of rows returned and if > 0 still jump to my HTML page but if 0 jump to a different html page.

I figure after the code to grab data is run I need an IF THEN ELSE statement where I evaluate some variable (?) and jump based on it.

Is there such a variable?

This message has been edited. Last edited by: FP Mod Chuck,

ROWCOUNT sounded Webfocusy...guess its not... but I stumbled upon &LINES....any issues around using that...I think it works...

something like this

TABLE FILE CAR
PRINT
CAR
ON TABLE HOLD AS RECORDCOUNT FORMAT ALPHA
END
-RUN
-SET &ROW_COUNT=&LINES;
-TYPE &ROW_COUNT


-IF &ORW_COUNT EQ 0 GOTO HTML_CODE;
-IF &ROW_COUNT NE 0 GOTO NEXT_CODE  

quote:

Is there such a variable?

&LINES: Is the number lines returned in the last answer set.

Reference: Statistical Variables