When I do MORE with 2 HOLD files, if one of them doesn't have any record, I get the error : FORMAT MISMATCH FOR THE FIELD. Do you have any solution for this.

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

This shouldn't happen.

Before the TABLE FILE with the MORE statement, check the two HOLD files by doing this in the code:

?FF HOLDFILE1
?FF HOLDFILE2

The columns should be in both files and they should have the same format.

The format mismatch error occurs if there is a format mismatch but also if one file has columns the other one doesn't.

Exactly!

See example:

  
-* File more01.fex
TABLE FILE CAR
SUM SALES BY CAR
ON TABLE HOLD AS H1
END

TABLE FILE CAR
SUM SALES BY CAR
IF CAR EQ XXX
ON TABLE HOLD AS H2
END

TABLE FILE H1
PRINT *
ON TABLE HOLD
MORE
FILE H2
END

And the run:

  
 0 NUMBER OF RECORDS IN TABLE=       18  LINES=     10
 0 NUMBER OF RECORDS IN TABLE=        0  LINES=      0
 0 NUMBER OF RECORDS IN TABLE=       10  LINES=     10

Danny,

what happens if the first ( H1 ) is empty?

Danny, I followed your code and it worked. I think my code is messed up a little bit so that's why I couldn't get the result.
Thanks all for your help.

Dave, master files get created even if there's no data, so the MORE will work...

Yes, I did test both cases and they worked.