RE: ADDING THE OUPUTS OF 2 CURSORS

> Dear Expert,
>
> I'm combining the outputs of 2 cursors into a single cursor to generate a report cursor.
>
> How do i proceed?


Assuming that these two cursors are identical (but holding different data), you can use APPEND FROM to pull the data into a third cursor:

SELECT ... FROM MyTable1 WHERE ... INTO CURSOR MyCursor1 NOFILTER 
SELECT ... FROM MyTable2 WHERE ... INTO CURSOR MyCursor2 NOFILTER  
*Make this cursor the same structure as your queries - it needs to be ReadWrite
CREATE CURSOR MyReportCursor (F1 I, F2 C(20), ...) 
APPEND FROM DBF("MyCursor1")
APPEND FROM DBF("MyCursor2")

In VFP 9 it gets a lot easier to do this

SELECT ... FROM MyTable1 WHERE ... INTO CURSOR MyCursor NOFILTER  
SELECT ... FROM MyTable2 WHERE ... INTO CURSOR MyReportCursor READWRITE
APPEND FROM DBF("MyCursor")

Ken
You shall know the truth - and the truth shall set you free. (John 8:33)