Jim,

The FOR clause is eqiuvalent to the SET FILTER approach IMO. The filtered grid thing IMO is the same as a BROWSE FOR command. Since we can't use a BROWSE as an Object, a SET FILTER in combination with a grid comes in.

I'll give another example:

USE sometable
USE Othertable in O order tag sometag
SET RELATION TO Expression INTO OtherTable

SET FILTER TO &cFilter

REPORT FORM (cReport) TO PRINTER PROMPT


Compare this with:

SELECT * FROM sometable INNER JOIN OtherTable ON Expr WHERE &cFilter INTO CURSOR Cursor

REPORT FORM (cReport) TO PRINTER PROMPT

In most cases I think, not only the xBase approach finishes printing earlier, but also executes faster.


Walter,

>USE SomeFile
>
>Later on ...
>
>REPORT FORM SomeRpt FOR &cFilter TO PRINT