Try
select * from sales1 ;
UNION ALL ;
select * from sales2 ;
into cursor temp readwrite
>how can I append the cursors?
>
>I have:
>
>
>select * from sales1 into cursor temp1
>select * from sales2 into cursor temp2
>
>
>temp1 and temp2 have the same columns.
>
>I want to add both into one cursor.
>
>if these are tables, I can use:
>
>
>use temp1
>append from dbf(temp2)
>
>
>how to do it with cursors?
>
>thanks for the help.
>
>regards,
>
>Jerry
If it's not broken, fix it until it is.
My Blog